Merge Data / Remove Duplicates without losing anything?

HitLeaks

New Member
Joined
Jan 24, 2015
Messages
23
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
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Re: Need Help | How to Merge Data / Remove Duplicates without loosing anything?

Still waiting for Pros help.
 
Upvote 0
Re: Need Help | How to Merge Data / Remove Duplicates without loosing anything?

Anybody here to help me please?

Regards
Asif
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,223,912
Messages
6,175,340
Members
452,638
Latest member
Oluwabukunmi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top