Normalizing a contact list for use in excel

[syncmaster152n]

Hey guys,

I've been tasked with entering a list of contacts into our database. The list is pretty long, so I want to upload it all into our dbase by reorganizing it all into a csv file. I need fields for name, title, organization, address, phone number, etc. problem is not all contacts have info for all fields. I'm having a hell of a time getting this data into a usable format. Can anyone help?

Data attached.

[AndyLitch]

Extract Addys.xlsm

This should be a step in the right direction

[syncmaster152n]

That definitely helps. Thank you!