Merge 3 Excel Files
- or -
Post a project like this627
£6(approx. $8)
- Posted:
- Proposals: 24
- Remote
- #3644129
- Awarded
A full time freelancer with expertise in various data analytics tool such as MS Excel, Power BI, GDA, etc.
Ahmedabad
8488076305892732037732627575696821946013760465776429997636698742390550499071607284
Description
Experience Level: Entry
Budget SET AS DEFAULT PRICE SO QUOTE BASED ON WHATR YOU WANT TO CHARGE
MERGE 3 DATA FILES ON EXCEL
Hi, I have 3 excel Files that require merging. Missing Data to be filled into the master spreadsheet.
The 3 files consist of the following number of rows (records):
File1: 20,393
File2: 34,011
File3: 62,500
I need to easily be able top differentiate between what records which are not matched in any other source file, a true unique Record. This can then be given an identifier in a new row to easily show the original source. e.g:
F1F2
F1
F3
F2F3
File 1 has the most non-unique records which basically is the primary list i am working from but there are a number of records missing attributes missing from each file so ideally the data will need to be collectively merged.
File 1 (20,000 records) is the main file with the most required data, so in turn there are only about 8 attributes in total that require filling from the other files whilst of course bringing over records that DO NOT match anything in FILE1.
There are 2/3 attributes that need be used to match the data across the files such as:
SKU CODE, BARCODE, MANUFACTURER CODE.
Any questions, let me know.
MERGE 3 DATA FILES ON EXCEL
Hi, I have 3 excel Files that require merging. Missing Data to be filled into the master spreadsheet.
The 3 files consist of the following number of rows (records):
File1: 20,393
File2: 34,011
File3: 62,500
I need to easily be able top differentiate between what records which are not matched in any other source file, a true unique Record. This can then be given an identifier in a new row to easily show the original source. e.g:
F1F2
F1
F3
F2F3
File 1 has the most non-unique records which basically is the primary list i am working from but there are a number of records missing attributes missing from each file so ideally the data will need to be collectively merged.
File 1 (20,000 records) is the main file with the most required data, so in turn there are only about 8 attributes in total that require filling from the other files whilst of course bringing over records that DO NOT match anything in FILE1.
There are 2/3 attributes that need be used to match the data across the files such as:
SKU CODE, BARCODE, MANUFACTURER CODE.
Any questions, let me know.
Bhav P.
100% (3)Projects Completed
4
Freelancers worked with
4
Projects awarded
9%
Last project
29 Jul 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
could you share your files please?
-
Can you pls share the excel files?
10280031027835
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