Removing Duplicates and Consolidating Data in A Single Row

Hi,

I have columns of data in many rows. These are contact details and the names are repeating in different rows sometimes as complete duplicates and sometimes containing different details in different columns. What I needs, is merge the unique data belonging to the same contact name and delete the duplicates. If there are no unique values, then simple remove the duplicate rows.

FN LN street name City State Zip Mail Address Mail City Mail State Mail Zip Phone#1 Phone#2 Phone#3
AB CD street name aaa aa xxxxx street name aaa aa xxxxx 999-999-99999
AB CD street name aaa aa xxxxx street name aaa aa xxxxx 888-888-88888
AB LK street name aaa aa xxxxx street name aaa aa xxxxx 999-999-99999 888-888-88888
AB LK street name aaa aa xxxxx street name aaa aa xxxxx 777-777-77777
AB LK street name aaa aa xxxxx street name aaa aa xxxxx

I need this to be
FN LN street name City State Zip Mail Address Mail City Mail State Mail Zip Phone#1 Phone#2 Phone#3
AB CD street name aaa aa xxxxx street name aaa aa xxxxx 999-999-99999 888-888-88888
AB LK street name bbb aa xxxxx street name bbb aa xxxxx 999-999-99999 888-888-88888 777-777-77777

Please check the attachment for more clarity.

I need coding to complete this work quick as I have thousands of rows of data.

Thanks

Try this:-

Please Login or Register  to view this content.

Regards Mick

Mick, YOU ARE AWESOME . Gosh.... You saved my life from manually doing this thing... Thanks a lot...

You're welcome

Hi Mick,

I have an issue. I noticed a thing. In my spreadsheet in some cells, I have data in subsequent cells. In the duplicate entries, while merging, it removes the data from the previous cell and updates the second data. It replaces the information in the first cell. I have inserted comments and highlighted the cells and attached. Please help me.

Best,
Joe

Try this:-

Please Login or Register  to view this content.

Regards Mick

It works perfectly. Thanks Mick.

You're welcome