Excel spreadsheet tidied up
- or -
Post a project like this3834
£10/hr(approx. $13/hr)
- Posted:
- Proposals: 2
- Remote
- #342338
- Awarded
Description
Experience Level: Entry
Estimated project duration: 1 day or less
I have a small mailing file 3,000 addresses in excel format.
It needs tidying up as below and then saving as a csv file. Please can you let me have a quote and let me know how quickly you can turn it around?
Merge the name columns together so that the name appears in one column. I’ve had a look through the file and the information contained within the columns is not consistent so when merging the columns you’ll need to be careful what’s in the column. The name starts in columns A, B and C, then it’s in column A merged and there’s address lines in B and C, then the name appears in A and B and there’s the company in column C then it goes back to A, B and C again.
From row 2121, the address appears in one cell. These will need to be split out as they are in the cells above it.
The file needs to be save as CSV(comma delimited).
It needs tidying up as below and then saving as a csv file. Please can you let me have a quote and let me know how quickly you can turn it around?
Merge the name columns together so that the name appears in one column. I’ve had a look through the file and the information contained within the columns is not consistent so when merging the columns you’ll need to be careful what’s in the column. The name starts in columns A, B and C, then it’s in column A merged and there’s address lines in B and C, then the name appears in A and B and there’s the company in column C then it goes back to A, B and C again.
From row 2121, the address appears in one cell. These will need to be split out as they are in the cells above it.
The file needs to be save as CSV(comma delimited).
Alex S.
100% (2)Projects Completed
2
Freelancers worked with
2
Projects awarded
33%
Last project
22 Jan 2021
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