Merge Data / Remove Duplicates without losing anything?

[HitLeaks]

Hi Team !

I have an excel sheet with at least 13k rows on it.

My rows titles are as under:-

1. Name
2. Title
3. Agency Name
4. Work Email
5. Personal Email
6. Location
7. Profile Link

I have too much duplicates on the sheet.

For example I have person named John Thomson and he has been duplicated for 2 x times. On some of his row he have work email but on another he have personal email.

I wanna merge his data in one row and wanna keep his full record (means none of his data should be lost).

Is there any fast solution to find, merge and remove duplicates?

Waiting for all professionals replies.

Kind Regards
HitLeaks

 

[HitLeaks]

Re: Need Help | How to Merge Data / Remove Duplicates without loosing anything?

Still waiting for Pros help.

 

[HitLeaks]

Re: Need Help | How to Merge Data / Remove Duplicates without loosing anything?

Anybody here to help me please?

Regards
Asif

 

[Joe4]

Re: Need Help | How to Merge Data / Remove Duplicates without loosing anything?

I think it would be helpful to actually see what your data looks like, and your expected results.

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.