Not just remove dup rows but combine columns
 

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

Not just remove dup rows but combine columns
 

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

"Colin" wrote in message
...
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