I have a database of names, addresses, and miscellaneous data that I'm trying to de-dup. The problem is that duplicate names and addresses do not have duplicate values in the other columns. What I need to do is combine the values for the other columns into one entry for each unique name and address.

What I'm trying to do is identical to using the subtotal tool, if only the subtotal tool allowed me to use the concatenate function, rather than, say, sum or average.

Any thoughts?