Not just remove dup rows but combine columns

[Colin]

I am trying to combine multiple contact lists - I want to not only get rid of
the dups, but unfortunately some duplicated rows have data in columns that
other rows don't. See below.

Last First Phone Phone 2 Email
Johnson David 917
Smith Jim 917
Johnson 212 dav@

I'd love to find some way that the above example would become:

Last First Phone Phone 2 Email
Johnson David 917 212 dav@
Smith Jim 917

Any help would be incredibly appreciated

 

[Ashish Mathur]

Hi,

The obvious question here is how does one know that Johnson and Johnson
David are the same

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com