Data cleaning and reformat
- or -
Post a project like this1913
$$$
- Posted:
- Proposals: 0
- Remote
- #2267701
- Awarded
Description
Experience Level: Expert
Estimated project duration: 1 day or less
Hello,
I have an excel file with vast amount of data. Aprox, 12000 rows and each row has about 6 columns.
Here's what I want:
1. I would like to have duplicate check.
2. I need separate columns like street, state, zip code, country from the address column.
3. Delete any line if the website column is empty. That's might be a few.
4. Reform the phone number like e.g xx xx xx xxxx
Don't need country code as they are all from same country.
5. In the website column, I want only domain names. Remove https www Stuffs
6. There would be around 43 category. I need them sorted and each category should be placed in separate sheet. Therefore, the final output will be around 5 files with 10 sheets on it.
Feel free to contact if you can't understand.
Looking for lower bid
Thanks
I have an excel file with vast amount of data. Aprox, 12000 rows and each row has about 6 columns.
Here's what I want:
1. I would like to have duplicate check.
2. I need separate columns like street, state, zip code, country from the address column.
3. Delete any line if the website column is empty. That's might be a few.
4. Reform the phone number like e.g xx xx xx xxxx
Don't need country code as they are all from same country.
5. In the website column, I want only domain names. Remove https www Stuffs
6. There would be around 43 category. I need them sorted and each category should be placed in separate sheet. Therefore, the final output will be around 5 files with 10 sheets on it.
Feel free to contact if you can't understand.
Looking for lower bid
Thanks
David H.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
0%
Last project
14 Jan 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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