
Combine two excel spreadsheets - immediate start, and follow work
3428
$
- Posted:
- Proposals: 6
- Remote
- #952687
- Archived
Graphic Design ,Presentation ,Online Marketing, YouTube Video Promotion,SEO and Data Entry Expert

4056761097003954127385741977595589018





Description
Experience Level: Entry
General information for the business: We are and IT consultancy and design datamodels
Industry: Internet/Software
Description of excel work: I have two spreadsheets with almost the same data in, but differently formatted. I need someone to combine them into s single spreadsheet.
I've attached the sample output file which defines the format of the data I want. I've added one sample record to demonstrate.
The other two files to merge are:
Document Report:
This contains the about 30 or so "Tables" - this data has been extracted from a PDF document and the formatting is a bit weird. The tables are named in the row before the table starts. there is some other redundant text that should be ignored. Each "Table" has four columns. The file to work on has 519 rows, I've attached a sample of the file with a few rows only.
Tables Report:
This contains the 31 "Tables", one per row with the "Fields" in the columns. This file has only the Field Names in it -so the other data must be captured from the Documents file, if it exists. I've attached a sample with 1 row only.
Most of the "Table" exist in each file. I want each table added once to the output file and the data merged from the two sources. If a Field exists in both , then add it once and mark it as existing in both. if it exists in only one the add it and marked as originating only from the file it came from. Ther is some variation in the naming of the fields. Spaces should be ignored and words in brackets should be ignored. there may be other small variations - please check with me
I'm looking for someone who can:
1. get the job dome accurately
2. offers good value
3. can complete the task quickly
4. can be trusted to work discreetly and confidentially
5. Would like further similar work in the future as a trusted partner
Please provide an estimate of the price and delivery date - I can send the full files immediately once I select someone.
Extra notes:
Industry: Internet/Software
Description of excel work: I have two spreadsheets with almost the same data in, but differently formatted. I need someone to combine them into s single spreadsheet.
I've attached the sample output file which defines the format of the data I want. I've added one sample record to demonstrate.
The other two files to merge are:
Document Report:
This contains the about 30 or so "Tables" - this data has been extracted from a PDF document and the formatting is a bit weird. The tables are named in the row before the table starts. there is some other redundant text that should be ignored. Each "Table" has four columns. The file to work on has 519 rows, I've attached a sample of the file with a few rows only.
Tables Report:
This contains the 31 "Tables", one per row with the "Fields" in the columns. This file has only the Field Names in it -so the other data must be captured from the Documents file, if it exists. I've attached a sample with 1 row only.
Most of the "Table" exist in each file. I want each table added once to the output file and the data merged from the two sources. If a Field exists in both , then add it once and mark it as existing in both. if it exists in only one the add it and marked as originating only from the file it came from. Ther is some variation in the naming of the fields. Spaces should be ignored and words in brackets should be ignored. there may be other small variations - please check with me
I'm looking for someone who can:
1. get the job dome accurately
2. offers good value
3. can complete the task quickly
4. can be trusted to work discreetly and confidentially
5. Would like further similar work in the future as a trusted partner
Please provide an estimate of the price and delivery date - I can send the full files immediately once I select someone.
Extra notes:

Andrew M.
100% (2)Projects Completed
8
Freelancers worked with
7
Projects awarded
54%
Last project
10 Feb 2020
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