I have been looking all over how to do this. I have a spreadsheet that has many contacts (8,000). I have many lines, not all, that have a contact duplicated but each line has a different piece of infomtion:
Example
Company Name Email Phone Fax
ABC company Joe Man jman@abc.com
ABC Company Joe Man 555-456-8974
ABC Company Joe Man 555-456-1212
Like I said not all lines are like this, some only have two![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
What is the best way to merge so all the information for one person is in one row?
Example
Company Name Email Phone Fax
ABC company Joe Man jman@abc.com
ABC Company Joe Man 555-456-8974
ABC Company Joe Man 555-456-1212
Like I said not all lines are like this, some only have two
What is the best way to merge so all the information for one person is in one row?