Microsoft Excel: Remove Duplicate Address but Keep Names
- or -
Post a project like this1720
$25
- Posted:
- Proposals: 24
- Remote
- #2033899
- Awarded
Data scraping / data mining / data extraction / web scraping / scraping / data conversion / General admin support and more

Microsoft Certified Advance Excel Specialist¦Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦Excel related any Work¦Macros of Excel¦

Data Scraping Expert - Web Scraping - Data Research - E-commerce Solution - All type of admin task

1267140139058495724564804679927930594101625214064161473077153899618568591907118




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