I have attached two files.
Excel help is a sample of the current database.
http://img155.imageshack.us/img155/8774/excelhelp.png
Excel help1 is a sample of the database format I want to have.
http://img838.imageshack.us/img838/8075/excelhelp1.png
Essentially I want to consolidate Name, Company, & Phone wheras if there are duplicates we combine the corresponding rows without losing any original data.
If someone could help me out with this I would be forever grateful.
Thank you so much !!
Excel help is a sample of the current database.
http://img155.imageshack.us/img155/8774/excelhelp.png
Excel help1 is a sample of the database format I want to have.
http://img838.imageshack.us/img838/8075/excelhelp1.png
Essentially I want to consolidate Name, Company, & Phone wheras if there are duplicates we combine the corresponding rows without losing any original data.
If someone could help me out with this I would be forever grateful.
Thank you so much !!
