concatenate problem

[joe peters]

I combined three different mail lists into one list, and need to remove
the duplicates. Unfortunately, each of the three lists has valuable
info that needs to be kept that the other two don't, so I can't simply
eliminate the duplicate names. I need to compress the values from each
entry into one entry.

Example:
5 columns: "Salutation", "First", "Last", "Address", "E-mail"

3 rows: each has the same First and Last name. One row has the e-mail,
one has the salutation, and the third has the address. How do I
compress the three entries into one?

There are some names that only occured on one or two lists rather than
all three that got combined, so there's no uniform number of entries
per person. This is why I'm thinking about the subtotal tool from the
Data menu - if I could run a concatenate subtotal for each change in
the name column, it would do the trick exactly.

 

[N Harkawat]

I would make a unique list of all first and last names using Data
Filter -Advanced filter --Unique
in a separate part of your w/sheet

Then do Vlookup for individual categories to go right next to the list that
you created above.