Delete duplicates?

Copper Contributor

So I am working with 3 spreadsheets to upload supplier information to a website. The 100kbulkupload is the one I used to upload the stuff onto the website. The SKU I have listed is the Supplier ID whereas it should have been the Stock Code (listed in the other two files)

 

Hlaentire is absolutely everything on the supplier list, which is what I was using. I have since found out that a bunch of this stuff is unavailable now so what I WANT to upload is the data from hlacomplete.

 

I need to replace the Supplier ID on the 100kbulkupload list with the stock code and also remove anything from the 100kbulkupload file that does NOT appear in the hlacomplete file. Finally I need to get the corresponding descriptions from column AP of the hlacomplete file into column O of the 100kbulkupload file.

 

I have had to upload them to google drive because I can only upload one on here and the files are huge.

100kbulkupload: https://drive.google.com/open?id=1oSLW2NB1g5lk3WITtaXzhRk3_wrUbSGu

hlacomplete: https://drive.google.com/open?id=1Lt2t8EDCjh1osydGfJI57BvoQy-px2X6

hlaentire: https://drive.google.com/open?id=1UKjm9FBuRmnzxcNsQbqX7EP_jd2jpExD

 

If anyone could help me out I would be most appreciative. I have messed around a little with deleting duplicates and such but am not confident enough in my abilities.

0 Replies