Microsoft Excel: Remove Duplicate Address but Keep Names
- or -
Post a project like this2120
$25
- Posted:
- Proposals: 23
- Remote
- #2033899
- Awarded
Data scraping / data mining / data extraction / web scraping / scraping / data conversion / General admin support and more
Kent
Administration Support, Data Entry Operator, Customer Support, Online mail Checker, Management Support
Dhaka
Web Scraping Expert - Data Scraping - Web Research - E-commerce Solution - All type of admin task
Ystrad Mynach
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
21174961390581955114190711818568591538996147307714064161016252930594564804495724
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