DataSheet Clean Up/Formatting

Closed

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.

Skills: Data Entry, Data Processing, Excel

See more: yellow characters, std remove if, medical special needs, freelancer worksheet, freelancer spaces, freelancer make up, freelancer fix price, freelancer dr, freelancer doctors, freelancer block, freelancer 2 characters, excel data entry worksheet form, delete review from freelancer, data entry form without excel, make up freelancer, dr freelancer, medical clinic, freelancer fee, extract phone number, Excel Formatting, dental clinic, data clean-up, clean-up, clean up, remove block

Project ID: #5256629

Awarded to:

Royalflush1986

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

$64 USD in 5 days
(6 Reviews)
2.6

25 freelancers are bidding on average $99 for this job

hossionsumon

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

$63 USD in 3 days
(169 Reviews)
6.8
enamulraju

Hello sir, i am master in excel , i know how to do this kind of work on Macro or formula, i have read the project and understand the out put you are looking for. waiting for your kind response to finish the work in tim More

$63 USD in 2 days
(165 Reviews)
6.4
pandey2008

Hello sir,we have good experience and we can start the work right now plz give us one chance we will do our best.thanx

$54 USD in 3 days
(104 Reviews)
5.7
dablu11

Hi! Thanks. After reading all instruction & understand. I'm willing to do this for you, can start immediately following your instruction. Honest sincere professional. Please give me the data sheet. Regar More

$64 USD in 3 days
(49 Reviews)
5.5
TypingxpertRehan

i have read the instructions i am ready to deliver you as they are 41k rows. i will go along with my bid thx

$200 USD in 4 days
(39 Reviews)
5.2
jenifa2008

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

$60 USD in 3 days
(43 Reviews)
4.7
Ibrahim185

sir, i am highly interested and dedicated to do this task. let's start. i am awaiting for your positive reply. thanks

$66 USD in 7 days
(40 Reviews)
4.7
dhnair

Seasons greetings, I read and understand this job requires a lot of patience, commitment and attention to detail. I am a person who possesses all these characters in abundance, and that is why I feel I am a good fit More

$55 USD in 5 days
(18 Reviews)
4.3
Midlander

A proposal has not yet been provided

$136 USD in 2 days
(6 Reviews)
4.0
rumapaul

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

$60 USD in 3 days
(7 Reviews)
3.1
kuberudu

Hi, I am interested to work on this project and have completed similar Excel and data entry work projects with 100% accuracy. Please let me know if we can get started. I can complete the project in on time. If I am abl More

$66 USD in 3 days
(12 Reviews)
3.0
ariftechno

Dear I read carefully your project detail and able to do this perfectly fast and cheap in rate. Please consider me for this project. Thanks

$50 USD in 2 days
(2 Reviews)
2.1
awalsumon

Hello i have read all your project description. Recently, i have completed an excel project. Please look my profile. thanks.

$60 USD in 3 days
(3 Reviews)
2.0
vcare77

Dear Hiring Manager, I can do this job efficiently and effectively Have a great day to you, I am interested to do this job and please see my elance profile link https://www.elan More

$67 USD in 3 days
(4 Reviews)
1.6
duttapapri

Hi, This is Papri dutta, belong from India. To proof myself, I will work harder and efficiently as your requirement. I'm very much flexible with my work / working time. I'm also having hold 2 years’ experienc More

$67 USD in 5 days
(1 Review)
0.2
harshitshah24

Hello, I am a regular Excel operator with the working knowledge on Excel. I understand that your projects needs some certainity and reliability with negligible errors and i aim to proceed towards that way. With my exce More

$144 USD in 3 days
(0 Reviews)
0.0
gautamq123

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
muhamedauda

I'm Expert in Excel .. ...... ... I have implement Excel Account Program for international company ... i you wish to work with be .. award my bid

$45 USD in 3 days
(0 Reviews)
0.0
Sudiptodas40

A proposal has not yet been provided

$40 USD in 2 days
(0 Reviews)
0.0
prabumathescse

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,

$155 USD in 3 days
(0 Reviews)
0.0