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