merge multiple rows combining duplicate and non-duplicate data into one row (constituent records)

[hcexxcel]

I have been compiling many many contact lists into a master excel sheet. Many customers were on multiple lists and are now on the master list multiple times (it is a large list) with many columns of categories and contact information. I need to combine duplicates --sometimes 2 duplicates of one person, sometimes 3 or 4-- each might have a different piece of info in a column but most have the same email address (that's what I was using to identify duplicates). Is there a way I can merge these in excel without losing data?

I need to clean the data up before it is loaded into a new CRM and don't really want to merge info for thousands of records by hand.

thank you!

 

[Kamolga]

Through a pivot table, if you put email first in row, you will normally have one line per email.

 

[hcexxcel]

Through a pivot table, if you put email first in row, you will normally have one line per email.

Hmm...not sure I understand. How would that allow me to merge multiple rows into one?


Thanks!