MasterSheet Merging/Deduplicating Excel Sheets
Budget: $30 – $250 USD
I have 227 Excel files in ".XLSX" format. I need them all merged and deduplicated then added to a workbook we'll call MasterSheet.XLSX. I need them to be deduplicated by Column C which always has a domain "https://www.aihitdata.com/company/00AA1B72/wes-engineering/overview" each domain is a link from a website called AIH from which the data was scraped and each domain is a link to a different company. I anticipate perhaps 600,000 total companies after deduplicating.
I need to combine this data into one file and deduplicate it by company using the link in Column C as the unique identifier. I also would like to add columns as many will be in, perhaps 9 categories. THE CATEGORY IS IN COLUMN A. I need that info on the Master Sheet so if we could add perhaps 8 columns and add every Category from Column A as a different column. So let's call them C1,C2,C3,C4,C5,C6,C7, and C8. Like...If Company ABC shows up first as a company under the "Electric" Category by Column A on the first search...we add "Electric" to C1. If he's found on a second file with "Exploration" as the category in Column A, we then add "Exploration" to C2 on the Master Sheet. The next time we add it to C3.
An example sheet is attached . Rest pon Drive link..
FILES LOCATED ON GOOGLE DRIVE AT:
https://drive.google.com/drive/folders/1Y3WMX8_aAtDIVm5Fx691OASWcUQrt5Hi?usp=sharing
I need to combine this data into one file and deduplicate it by company using the link in Column C as the unique identifier. I also would like to add columns as many will be in, perhaps 9 categories. THE CATEGORY IS IN COLUMN A. I need that info on the Master Sheet so if we could add perhaps 8 columns and add every Category from Column A as a different column. So let's call them C1,C2,C3,C4,C5,C6,C7, and C8. Like...If Company ABC shows up first as a company under the "Electric" Category by Column A on the first search...we add "Electric" to C1. If he's found on a second file with "Exploration" as the category in Column A, we then add "Exploration" to C2 on the Master Sheet. The next time we add it to C3.
An example sheet is attached . Rest pon Drive link..
FILES LOCATED ON GOOGLE DRIVE AT:
https://drive.google.com/drive/folders/1Y3WMX8_aAtDIVm5Fx691OASWcUQrt5Hi?usp=sharing