Question: are all your records like:

John Doe 1 A street
Jane Doe 3 B str
John Doe 212-555-5555
Mike Doe 7 C str
John Doe affil1
Jane Doe 313-444-4444
Mike Doe 414-666-6666
Jane Doe affil2
Mike Doe affil3

In other words, (1) do you always have the key in first column? (2) is
phone always in a later row than address and affiliation in a later
row than phone?



On Jul 2, 7:43 pm, Danielle
wrote:
I have an excel spreadsheet with lots of duplicate contacts, but their
information is spread throughout the different rows. For example, I have 3
rows for John Doe, but his address is in the first row, his phone number is
in the second row, and his affiliation is in the third row.

Is there a way to merge the information from all three rows into one? I have
a few thousand records like this.

Thanks!