522 Companies and 8872 People to be transfered from one spreadsheet to 2 spreadsheets
- or -
Post a project like this2607
$$
- Posted:
- Proposals: 18
- Remote
- #1461019
- Awarded
Excel VBA, MS PRoject Expert, Web Scraper, Arena, Simulation, Spreadsheet, Wordpress customisation
Istanbul
Web Design/Animation/Web Developer / Magento / Wordpress / Project Management / Drupal / Whitebored Video / Editor/Responsive Design /
New York City
Virtual Assistant, Personal Assistant, Event Assistant, IT Support, Administration support, Business Support, Data Entry, Excel, Lead Generation, Web Research,
City of London
323952130044915401761796411533433153074613900461387594124056711996371009681856358
Description
Experience Level: Intermediate
Description of excel work: Hi,
I currently have one spreadsheet, I have attached a sample (raw data). This includes details of 522 companies across the UK with details of 2833 Directors and 6039 Management within the companies.
I need this information to be split across two seperate spreadsheets : one company and one people (both attached)
Need the following transfered across to each spreadsheet from the one -
Company Template :
Company Name
Address - Needs to be split on raw data to 6 columns max (as per company template)
Phone Number
Website
Company size
Turnover
People Template :
Company Name
Company Town - pulled from above when address has been split
Company Postcode - pulled from above when address has been split
Company County - pulled from above when address has been split
Company Country - pulled from above when address has been split
First Name and Surname (split) of all directors and contacts within each company (Column L&O on raw)
Job Title (Column M&P on raw)
Thanks
Extra notes:
I currently have one spreadsheet, I have attached a sample (raw data). This includes details of 522 companies across the UK with details of 2833 Directors and 6039 Management within the companies.
I need this information to be split across two seperate spreadsheets : one company and one people (both attached)
Need the following transfered across to each spreadsheet from the one -
Company Template :
Company Name
Address - Needs to be split on raw data to 6 columns max (as per company template)
Phone Number
Website
Company size
Turnover
People Template :
Company Name
Company Town - pulled from above when address has been split
Company Postcode - pulled from above when address has been split
Company County - pulled from above when address has been split
Company Country - pulled from above when address has been split
First Name and Surname (split) of all directors and contacts within each company (Column L&O on raw)
Job Title (Column M&P on raw)
Thanks
Extra notes:
Projects Completed
19
Freelancers worked with
20
Projects awarded
39%
Last project
3 May 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