Hi, I want to merge 2 excel SpreadSheets in one unique page.
First SpreadSheet called Product List n has 26538 rows if I count the header row too.
The second SpreadSheet called OEM Product List and has 16682 rows.
Many of second page rows has itmes from the first page but with extra or less titles in the headers.
Same think with the first page. it has items that are in the second page but with different number of titles on the header.
Im not sure if the second page has any items that are not in the first page. But for sure the first page has items that are not on the second page.
Now I want them to merge their headers, and merge the rows, and extract all double rows based on SKU number of both of them. I want you to save a copy of the removed extra doubles if any from first and second page and then from after you merge the 2 pages together.
The unique page must have at the end must have unique SKU.
Let say per example the total of the rows in the new unique file wil be 30000. Just as example.
Now I have about 30831 image in a folder. Their IDs go by same number as the SKUs in the excel file.
There is more Images than the one in the items on the excel file. I want you to extract the extra images that not on the excel file SKUs number, then save a copy of them and leave the image folder of the ones apply to the excel file in the original folder. The goal is that I want to upload all the excel unique spreed sheet to the website and upload the only applicable images to the website also after you give me a clean work with all the extra copy saved of the duplicates and the extra images.
If you agree about getting payed $10 I need this work to be done in 3 hours and finished by 9PM New York time. Now its 6PM NY time. I will have more work for you periodically. If you cant do it in time please don't replay so I can have some body else to do it. here are the excel file. I will send you the images when you are don't with the excel unique files. Thank you!
Được trao cho:
5 freelancer chào giá trung bình$77 cho công việc này
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi