Merging duplicate rows and combining field values from the duplicates

[moishier]

I have one table that contains many duplicate rows. The duplicates will be identified based on matches on first name, last name, email and/or phone.

The rows also contain a column of data in a column called "data". This is a text field.

I need to merge the duplicate rows into one row but retain the values of "data" from both rows into a single merged column of "data" (i.e. concatenate the text field) (or even two columns of "data" from the duplicates that I can then later merge). The duplicate rows will then be deleted.

How can this be accomplished?

 

[jpaokx]

If I understand this correctly, I would suggest you follow these steps:

1) sort the data,
2) create a column and give group numbers for the duplicate records,
3) create another column and concatenate the text fields by using the group numbers (e.g. an IIf() function should work)
4) Copy the table and paste as structure only and you'll have an empty table.
5) Set the primary keys for the field to either the concatenated text field or the group number field or both,
6) Append the populated table to the empty one,
7) Delete any unnecessary fields.
8) Done!

 

[moishier]

I found the solution in an excel add-in from Ablebits data.

 

[Sean O'Halloran]

And that solution was? Link? Description?