I have two lists of products that are different for code and price. I have to compare them and get a third list that as the list 1, but without the codes that we are on the list 2.
Then compare two excel sheets (1 of 4 columns SKU, DESCRIPTION, Price1, ID and 1 in 3 columns SKU, DESCRIPTION Rate2) and create a third sheet that is the union of the previous two.
The third sheet must:
- Have 4 columns (SKU, DESCRIPTION, Price1, Rate2, ID)
- If some SKUs are not on the list 1 list 2 leave all the other fields blank so that I can see which SKU is not in the list 1 list 2
lines should not mix but each SKU, DESCRIPTION PRICE ID and must bind to each other (the ID is linked to and SKU DESCRIPTION and PRICE)
tables have about 8000 lines one o'clock
fornisto the two lists. In response I would like an excel file that I can use in the future.
27 freelancers are bidding on average $61 for this job
Please let me get the 2 files so that i can prepare the third one and can see practically how time is taking to prepare this. Thanks for your understanding.
Hi, I'm proficient in MS Excel and I can help you with this project. I can ensure you great work quality. Please check out my profile and previous reviews. Thanks.
I'm a Professional Data Entry Operator. I have a lot of experience on Data Processing, Excel etc. I can assure you quality service. Please consider my bid and let me start asap. Thanks
Hi, I am interested to work on this project. I have 12+ years of experience in building Excel spreadsheets and can deliver your work in 2 days. Regards