Hello - I have a spreadsheet that has 36,000 records. Each record has 15 text fields shown below. Most of the records have the address combined in one fields such as "985 Parker [url removed, login to view] Clara, CA 95050" .... I need someone to do three things to the data set.
1. Break the address into the individual fields such as:
Address = 985 Parker Ct.
City = Santa Clara
State = CA
Zip = 95050
2. Convert all UPPERCASE text to Sentence Case.
3. Deduplicate the records based on the "Company" field... Deduplicate by using one address, phone and email
and then combine the data from the other duplicate fields.
15 freelancers are bidding on average $120 for this job
I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.
I am expert in excel and have 3 year experience in [url removed, login to view] i am doing working for a firm where i am handle 2500 worker sallary and other expense through [url removed, login to view] Give me a chance for work.
Hi I am a new freelancer with 9+ years experience in PHP, Java, MySQL, SQLServer and Data scraping. I feel I can do this in a day or two if my understanding is correct. Rest I am putting on your PM.