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

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
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,243
Messages
6,170,967
Members
452,371
Latest member
Frana

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