I need data from an excel spreadsheet organising manually- Part 1 of 2
- or -
Post a project like this3317
£50(approx. $62)
- Posted:
- Proposals: 16
- Remote
- #699500
- Awarded
Ms Word, Ms Excel, Ms Powerpoint,Data entry, Interner Research, Data Mining, Data Scraping,
Kolkata
Business Consultant, Website Design, Website Development, PHP, WordPress, Web App, Mobile App, Branding, Designer, Business Plans, Business Support, Presentation, Adviser, Analyst, Strategist, Advisor
City of London
Graphic Designer | Social Media Post Designer | Menu Cards Designer | Logo Designer | Poster Designer
North Karachi
a hard-worker, good at paying attention to detail and assist my clients as per their requirement
Denpasar
363659274407376080485147488811579409698473735997762794855172866990868667
Description
Experience Level: Intermediate
PRICE NEGOTIABLE AND FURTHER TO THIS...THIS IS PART 1 OF 2 PIECES OF WORK!!!!! The winning proposal will also be offered a second piece of work that is similar but will give the spec for this. Please make me aware of how long you expect this to take!
I have around 70000 rows that need to be checked on the later to be attached spreadsheet. The attached examples show firstly how the data will come to you (example of work pre changes) and then the second attachment of how it should look (example of how it should look).
The only columns you will need to work on are B-H. Columns F,G,H must have information in these fields.
The quickest way to sort the later 70, 000 entries is to sort by postcode so you can work down the multiple entries for each city etc and move them across.
Please make sure the following fields for the address all have information (If there is no info in the other fields for this you will have to search the business online and add this in accordingly). Please note. Most of the information will be in the fields to the left starting in Column B
Do NOT delete any columns or cells!
Region- Will always be a Region (also can be called county). If you google the postcode the county will be shown in the search results
City- Must be filled in, so if something in the Town Field move across into this column
Where you see a number in one column this will be typically need adding to what is already in the column to the right of the number. This will normally be the number of an address for the road or street name
If you find an address without a postcode please check the business website or on google to see if this is listed and update accordingly
If limited address or no address given please google the business name and try and find as much information about the business address as possible
Where you see a number in one column and address line in the next then please combine the two, e.g. row 3 Column B (80a) needs to combine with Column C so its reads (80a Broomhill Rd)
Please also where you see rd change to Road
Please where you see st change to Street
Please where you see av change to Avenue
Row 6 as an example…
Column E moves to Col G
Column D moves to Col F
Column B needs to combine with Column C…THEN once done Column C moves to Column D
If anything is in capital letters then please have first word capital letter and the rest lower case, e.g. NORTH SHIELDS should be North Shields.
I have around 70000 rows that need to be checked on the later to be attached spreadsheet. The attached examples show firstly how the data will come to you (example of work pre changes) and then the second attachment of how it should look (example of how it should look).
The only columns you will need to work on are B-H. Columns F,G,H must have information in these fields.
The quickest way to sort the later 70, 000 entries is to sort by postcode so you can work down the multiple entries for each city etc and move them across.
Please make sure the following fields for the address all have information (If there is no info in the other fields for this you will have to search the business online and add this in accordingly). Please note. Most of the information will be in the fields to the left starting in Column B
Do NOT delete any columns or cells!
Region- Will always be a Region (also can be called county). If you google the postcode the county will be shown in the search results
City- Must be filled in, so if something in the Town Field move across into this column
Where you see a number in one column this will be typically need adding to what is already in the column to the right of the number. This will normally be the number of an address for the road or street name
If you find an address without a postcode please check the business website or on google to see if this is listed and update accordingly
If limited address or no address given please google the business name and try and find as much information about the business address as possible
Where you see a number in one column and address line in the next then please combine the two, e.g. row 3 Column B (80a) needs to combine with Column C so its reads (80a Broomhill Rd)
Please also where you see rd change to Road
Please where you see st change to Street
Please where you see av change to Avenue
Row 6 as an example…
Column E moves to Col G
Column D moves to Col F
Column B needs to combine with Column C…THEN once done Column C moves to Column D
If anything is in capital letters then please have first word capital letter and the rest lower case, e.g. NORTH SHIELDS should be North Shields.
Shaun W.
100% (151)Projects Completed
73
Freelancers worked with
49
Projects awarded
28%
Last project
10 Apr 2024
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