
Microsoft Excel: Remove Duplicate Address but Keep Names
- or -
Post a project like this2578
$25
- Posted:
- Proposals: 23
- Remote
- #2033899
- Awarded
Hire Nida T as your fashion designer Resume editor ,CV writer.curriculam vitae editor.whiteboard animator,proofreader, catchy domain name developer.
Administration Support, Data Entry Operator, Customer Support, Online mail Checker, Management Support
Data scraping / data mining / data extraction / web scraping / scraping / data conversion / General admin support and more

1267140190711815389962117496218855822481112216017495724101625219551141390582169021




Description
Experience Level: Intermediate
Have an Excel list with about 7623 names and addresses. However most of those addresses are duplicates because of multiple people living at the address. I want to remove the duplicate addresses but keep the names of the individuals living in the home in the first name column only, leaving the last name column blank.
Eg:
John Smith, 123 Smith Road
Vernon Johnson, 123 Smith Road
James Adams, 123 Smith Road
John Smith
Vernon Johnson
James Adams
123 Smith Road
Eg:
John Smith, 123 Smith Road
Vernon Johnson, 123 Smith Road
James Adams, 123 Smith Road
John Smith
Vernon Johnson
James Adams
123 Smith Road

Yrneh E.
93% (3)Projects Completed
2
Freelancers worked with
2
Projects awarded
43%
Last project
17 Jul 2019
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
hello Yrneh E
if this job is still available then let me know. i will do this project within few hours
thanks
653885
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies