Hi All,
I hope this is a simple question.
I am working to compile several peoples contact list. I merged all of the contact list into one excel file and have four columns.
Column A is the e-mail address
Column B is the First Name of the Contact
Column C is the Last Name of the Contact
Column D list which person's contact list the contact came from.
My problem is that I discovered duplicates in Column A.
I would like to Merge the duplicates into one row and have Column D reflect all of the list the contact came from.
Right now I have one excel file with all the duplicates removed and "multiple" in Column D.
I have a second file that is "raw" with duplicates.
Any suggestions?
I hope this is a simple question.
I am working to compile several peoples contact list. I merged all of the contact list into one excel file and have four columns.
Column A is the e-mail address
Column B is the First Name of the Contact
Column C is the Last Name of the Contact
Column D list which person's contact list the contact came from.
My problem is that I discovered duplicates in Column A.
I would like to Merge the duplicates into one row and have Column D reflect all of the list the contact came from.
Right now I have one excel file with all the duplicates removed and "multiple" in Column D.
I have a second file that is "raw" with duplicates.
Any suggestions?