Not just remove dup rows but combine columns

  • Thread starter Thread starter Colin
  • Start date Start date
C

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
 
Back
Top