Requirements for Excel Clean up Project. *******Price fixed: $60+freelancer fee. *******
Please do NOT extract data. You must make edits in this worksheet (40,634 rows) and keep it intact.
You must review the ENTIRE WORKSHEET (ALL 40,634 ROWS) for the below to see where edits needed. Obviously, not every record has an issue and a lot of records are fine.
1) Ensure data aligns with the correct column heading (as one example, check that the address is actually under the address column)
2) The city/state columns must be fixed so they match the city/state listed in the address column. The address column is always correct SO pls use that as the guide.
3) Fix "Phone No" column. The correct std must be used, which must match the city/state in the address column. Phone number should be in the format std code-number without any spaces, special characters (e.g 011-22145673). Only one number per cell allowed. If the number is bad (cannot form a whole phone number with std code), delete it.
4) The clinic name and doctors name should be fixed where needed. Example - If clinic name i Dr Avy Dental And Medical Clinic, Doctors name should be Dr. Avy
5) Formatting needs fixing - remove block letters in names, addresses. Example- name should be Dr. Rao, not "DR. RAO"
6) All breaks/yellow rows in data set should be removed so dataset reads as a whole
7) Pin Code column - if the address column contains the pin code, copy that pin code into the pin code column (dont delete pin code from address column in the process.) if not pincode in address column, skip this.
Hi, Please allow me to this job for you. I assure you that you will get 100% outcome. Please award me if you were satisfied with my previous work. Best Regards, Nishith Gupta
25 freelancers are bidding on average $99 for this job
Dear sir/Mam, Let's start work right now and finished asap.I've lot's of experience similar project.I look forward to hearing from you.I know XL Formula to finish it quickly.I will complete it accurately no problem
Dear Project Owner, I am interested in this project. I have understood the project requirement and able to complete this very carefully. wish to get response from you. Thanks
Hello Greetings I read the project description.I can do this work. Being Indian i have thorough know about Pin codes Kindly PM for further communication Waiting for your positive response Thank You
Hi. Thank you for the opportunity extended. Please let me know if you have any data entry work for me Looking forward to hear from your end. Regards, Prabakar,