Combine two excel documents into one
- or -
Post a project like this3505
£10(approx. $13)
- Posted:
- Proposals: 8
- Remote
- #626010
- Completed
Freelance Worker - takingthestrain.co.uk - Website design, Social Media. Business Support and more
Pontypool
Virtual Assistant, data entry, data analysis, Excel, Lead generation, Email marketing, Graphics design. dataentry
Dhaka
58610844372053064957596366193614937642393790325
Description
Experience Level: Entry
Description of excel work: We currently have two excel files that we need to combine into one file:
[file A] has 23,000 text lines
[file B] has 2500 text lines (from file A)
File A has a number of columns such as Title | Description | Price | SKU | Colour | Etc.
File B has only one column of SKU
We need you to create a new file [file C] that includes all the columns of file A, BUT show only the 2500 lines of file B. Basically, match SKU = SKU and hide all the rest. To explain again, we need the information of file A, based only on the 2500 SKUs of file B.
Should be a quick job for someone who knows excel.
Extra notes:
[file A] has 23,000 text lines
[file B] has 2500 text lines (from file A)
File A has a number of columns such as Title | Description | Price | SKU | Colour | Etc.
File B has only one column of SKU
We need you to create a new file [file C] that includes all the columns of file A, BUT show only the 2500 lines of file B. Basically, match SKU = SKU and hide all the rest. To explain again, we need the information of file A, based only on the 2500 SKUs of file B.
Should be a quick job for someone who knows excel.
Extra notes:
Ran N.
100% (106)Projects Completed
36
Freelancers worked with
31
Projects awarded
43%
Last project
3 Jan 2022
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