Microsoft Excel: Remove Duplicate Address but Keep Names
- or -
Post a project like this2138
$25
- Posted:
- Proposals: 23
- Remote
- #2033899
- Awarded
Transcription, PDF conversion, Business reporting, Banner design, Fillable PDF form, PDF Editing, Adobe Acrobat, Typing data entry, MS word, MS Excel
Bangalore
Hire Nida T as your fashion designer Resume editor ,CV writer.curriculam vitae editor.whiteboard animator,proofreader, catchy domain name developer.
Sargodha
B2B Lead Generation, Data Entry, Web Research, Web Scraping, Virtual Assistant, Email List Building, Prospect List Building, Email Finding, LinkedIn Lead Generation, Excel Data Entry, Email Marketing.
Thakurgaon
12671402025089225566222530592248111221601721885582183983216902121507522121644
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