Remove duplicates but combine information into one row?

[Dan1027]

I want to remove duplicate names, but fill incomplete information into one complete row. For example

Column A
First Name

Column B
Last Name

Column C
Address

Column D
Phone Number

My cells have something like:

John Doe 1234 S Chicago
John Doe 333-333-3333

I want one row to say

John Doe 1234 S Chicago 333-333-3333


I have a large set of data with duplicate persons, but with missing information from their rows. I want to merge it all into one complete row. Any ideas?

Thanks!

Dan

[GC Excel]

Hello and welcome to the forum,

A VBA solution might work....

Do you have the same number of rows for each persons?
Can you provide a workbook with sample data.

[mangesh.mehendale]

Easy...

Please Login or Register  to view this content.

Remove duplication after you concatenate using above way

see attached file

[Dan1027]

Ex.xlsx

Hi, I've attached the file I'm working on. Unfortunately I am still unable to get this resolved. Much appreciated for the help!

[GC Excel]

Hi Dan1027,

Please try the following macro. It loops thru all names in 1A tab and store information for each of them in a dictionary, the output the result to 1B tab

Please Login or Register  to view this content.