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

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" <Colin@discussions.microsoft.com> wrote in message 
news:0B0EE125-CB15-4D7C-A3B1-1BC5071F2047@microsoft.com...
> 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