Data Consolidation (3 spreadsheets into 1, some manual mapping / intervention)
- or -
Post a project like this2328
$$$
- Posted:
- Proposals: 16
- Remote
- #1784339
- Awarded
Excel Expert, Excel Spreadsheets, Excel VBA & Access Database Developer, Data modelling & Analysis
London
TOP CERT Virtual Assistant, Data Analyst, Proofreader, Excel, Word and PowerPoint Trainer
Swindon
Excel and VBA expert. Professional OCR. PDF to Excel Conversion. Data management, Translations English Russian
Hua Hin
Excel VBA, MS PRoject Expert, Web Scraper, Arena, Simulation, Spreadsheet, Wordpress customisation
Istanbul
Data Entry, Social Media, Proof Reading, Financial Services, Surveyor's, Business Analyst, Designing, Letter Head, Flyers, Digital Marketing,
Lahore
903273120945158266077877526491104630122469012491701300449145176914728081618289
Description
Experience Level: Expert
Estimated project duration: 1 day or less
Industry: Internet/Software
Analysis tool: Excel
Description of analysis: We need to consolidate data from 3 different contact/company information spreadsheets into one spreadsheet. The ultimate spreadsheet will have 2000 contacts maximum. The unique identifying column will naturally be the company name, however, this name will not necessarily be spelt the same in each spreadsheet. The spreadsheet with email addresses will be a lot larger than the other spreadsheets but clearly, we will only want emails related to the 2000 contacts to be imported, hence the need for assistance. I have attached 2 template spreadsheets so that you can see the structure of the columns: Template A & Template B. The 3rd spreadsheet is the ultimate consolidation spreadsheet that I want to be created. I also have a 4th template which is the one with the email addresses. PPH won't let me upload a 4th one! It will just show the following columns: Contact Name, Company Name, Position, City, Post Code, Email Address
Extra notes: Work needs to be delivered by 16th November 2017 latest, ideally before.
Analysis tool: Excel
Description of analysis: We need to consolidate data from 3 different contact/company information spreadsheets into one spreadsheet. The ultimate spreadsheet will have 2000 contacts maximum. The unique identifying column will naturally be the company name, however, this name will not necessarily be spelt the same in each spreadsheet. The spreadsheet with email addresses will be a lot larger than the other spreadsheets but clearly, we will only want emails related to the 2000 contacts to be imported, hence the need for assistance. I have attached 2 template spreadsheets so that you can see the structure of the columns: Template A & Template B. The 3rd spreadsheet is the ultimate consolidation spreadsheet that I want to be created. I also have a 4th template which is the one with the email addresses. PPH won't let me upload a 4th one! It will just show the following columns: Contact Name, Company Name, Position, City, Post Code, Email Address
Extra notes: Work needs to be delivered by 16th November 2017 latest, ideally before.
Simon G.
0% (0)Projects Completed
2
Freelancers worked with
2
Projects awarded
100%
Last project
20 Nov 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Simon,
that's quite simple, have you found someone for this?
cheers,
Agnes
537993
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