Address List Transpose Into Microsoft Excel Columns Table
- or -
Post a project like this1762
£20(approx. $25)
- Posted:
- Proposals: 12
- Remote
- #2430112
- Awarded
Data Entry Operator, Word, Excel Expert | Fillable PDF Form | Edit PDF | Audio Editer
Colombo
Wordpress Developer *Full Stack Web Developer * Shopify Developer*PHP* REACT JS
Islamabad
Writer, Social Media Specialist, Artist, Graphical Design, Composing, Resume Writing, Editing
Belgrade
36844738574157152696345113650061711586241923725367582545245261258527800952781493
Description
Experience Level: Entry
Estimated project duration: less than 1 week
Required by Monday AM - UK time.
The task is to turn a long list of addresses in an excel column running vertically into a list of records in an excel table with column headers. There are almost always gaps in the column which indicates where one record ends and another one begins.
To achieve the task, the freelancer will need to transpose the horizontal data into vertical data, I guess using formulas or VBA.
The data is not always uniform in size. The data is nearly all 6 rows long, but not always. Sometimes it is 5 or 7 rows or more or less, but these are rare cases. In some cases two addresses flow together and these will need to be split. Sometimes address 1 and address 2, or address 2 and town, need to be split into two separate columns for data accuracy.
In order to achieve this task quickly and accurately, the freelancer needs to have the right excel skills, ideally a working knowledge of British address formats and familiarity with British place names. Attention to detail is of very high importance because I don't want to have to manipulate the data again afterwards or make corrections. The successful freelancer, with the correct skills, speed and accuracy, can be assured of more work like this in the future from our company.
You are welcome to ask questions to me throughout the task that help you achieve accuracy.
Best Regards
Chad Millington
The task is to turn a long list of addresses in an excel column running vertically into a list of records in an excel table with column headers. There are almost always gaps in the column which indicates where one record ends and another one begins.
To achieve the task, the freelancer will need to transpose the horizontal data into vertical data, I guess using formulas or VBA.
The data is not always uniform in size. The data is nearly all 6 rows long, but not always. Sometimes it is 5 or 7 rows or more or less, but these are rare cases. In some cases two addresses flow together and these will need to be split. Sometimes address 1 and address 2, or address 2 and town, need to be split into two separate columns for data accuracy.
In order to achieve this task quickly and accurately, the freelancer needs to have the right excel skills, ideally a working knowledge of British address formats and familiarity with British place names. Attention to detail is of very high importance because I don't want to have to manipulate the data again afterwards or make corrections. The successful freelancer, with the correct skills, speed and accuracy, can be assured of more work like this in the future from our company.
You are welcome to ask questions to me throughout the task that help you achieve accuracy.
Best Regards
Chad Millington
Chad M.
99% (18)Projects Completed
13
Freelancers worked with
15
Projects awarded
56%
Last project
16 Mar 2022
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