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

Hi, welcome to the forum

It often happens that a copy/paste to the forum, does not show the data the way you wanted it to - this is 1 of those times

Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Also, my VBA is weak, but I could probably do this with a formula, if you are OK with that?

Deleted forum-induced duplicate