04-08-2010 12:14 PM
I hope someone can help with this issue I have is that the company Excel spreadsheet that have imported. Each company has a seperate row of cells that have the same information except the contact name and title cells at the end of each row. So Company A has five rows, with identical address, phone info and so on, but the last few cells contains unique contacts name information and titles.
The imported database shows 5 separate rows (records) that I'd like to consolidate into one record with multiple contacts. I've done a series of different imports without solving the problem. How's it done?