Conversion of two large spreadsheets into one large matrix
- or -
Post a project like this12
£60(approx. $75)
- Posted:
- Proposals: 11
- Remote
- #4192673
- Awarded
Data scraping / data mining / data extraction / web scraping / scraping / data conversion / General admin support and more
Kent
PPH TOP Website & App Developer✮LOGO & Graphic Designer✮Content Writer✮Translator
Dubai
1355454506661390586329171237383149706022748042557369274675236848477870242
Description
Experience Level: Entry
I have two large excel spreadsheets, each with hundreds of tabs, and each tab has approximately 7000 "Part number" lines in it.
MANY of the part numbers are duplicated across multiple tabs and it is estimated that there are only 30k to 50k unique part numbers
Data task create a matrix in a single worksheet, with every unique part number.
- Unique part number on spreadsheet rows, with the product title, group name and subgroup name.
- Headers named after each unique tab.
- Y/N Entries as to whether that part number appears in that tab name.
Attached screenshot shows a small portion of the data in its current raw form.
Attached spreadsheet "EXAMPLE DATA' shows the desired outcome.
Finished spreadsheet will have more than 300 header names, named after each tab.
MANY of the part numbers are duplicated across multiple tabs and it is estimated that there are only 30k to 50k unique part numbers
Data task create a matrix in a single worksheet, with every unique part number.
- Unique part number on spreadsheet rows, with the product title, group name and subgroup name.
- Headers named after each unique tab.
- Y/N Entries as to whether that part number appears in that tab name.
Attached screenshot shows a small portion of the data in its current raw form.
Attached spreadsheet "EXAMPLE DATA' shows the desired outcome.
Finished spreadsheet will have more than 300 header names, named after each tab.
Stephanie E.
100% (5)Projects Completed
4
Freelancers worked with
4
Projects awarded
100%
Last project
29 Apr 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