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!