Hi MarvinP,

Your solution works when we know what column we want to merge (ie names) but if we don't know which column should be merged as in the example of a spreadsheet where two different users have been adding different data beginning with the same table and for a record on each row, each user has been adding data to different columns. I combined tables created by both users but ended up with duplicate records with new data in different columns. How would I go about merging these "duplicate" records but keeping the data both users added? Thanks.

EduD