Posting an example of your problem would probably garner you several
efficient means for accomplishing your task

"joe peters" wrote:


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?


--
joe peters