I have an excel table that has 3 columns: company name, employee name, and work address/phone. There are 454 companies, but half or so are duplicates. I need someone to (1) eliminate duplicates (2) fix data that was improperly formatted. The revised excel table must have separate columns for company name, employee first name, employee last name, employee work email, employee phone, employee fax, employer website address, employer street, employer city, employer state, employer zip. All info is in the sheet, but email is currently hyperlinked so you have to look at the hyperlink to capture the email address which also tells you the company website.
13 freelancers are bidding on average $63 for this job
I have the required competence and necessary software tools to turn around your requirement with 100% accuracy. Please check PM for further details. Thanks