Home

Delete duplicates?

%3CLINGO-SUB%20id%3D%22lingo-sub-293715%22%20slang%3D%22en-US%22%3EDelete%20duplicates%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293715%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I%20am%20working%20with%203%20spreadsheets%20to%20upload%20supplier%20information%20to%20a%20website.%20The%20100kbulkupload%20is%20the%20one%20I%20used%20to%20upload%20the%20stuff%20onto%20the%20website.%20The%20SKU%20I%20have%20listed%20is%20the%20Supplier%20ID%20whereas%20it%20should%20have%20been%20the%20Stock%20Code%20(listed%20in%20the%20other%20two%20files)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHlaentire%20is%20absolutely%20everything%20on%20the%20supplier%20list%2C%20which%20is%20what%20I%20was%20using.%20I%20have%20since%20found%20out%20that%20a%20bunch%20of%20this%20stuff%20is%20unavailable%20now%20so%20what%20I%20WANT%20to%20upload%20is%20the%20data%20from%20hlacomplete.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20replace%20the%20Supplier%20ID%20on%20the%20100kbulkupload%20list%20with%20the%20stock%20code%20and%20also%20remove%20anything%20from%20the%20100kbulkupload%20file%20that%20does%20NOT%20appear%20in%20the%20hlacomplete%20file.%20Finally%20I%20need%20to%20get%20the%20corresponding%20descriptions%20from%20column%20AP%20of%20the%20hlacomplete%20file%20into%20column%20O%20of%20the%20100kbulkupload%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20had%20to%20upload%20them%20to%20google%20drive%20because%20I%20can%20only%20upload%20one%20on%20here%20and%20the%20files%20are%20huge.%3C%2FP%3E%3CP%3E100kbulkupload%3A%20%3CA%20href%3D%22https%3A%2F%2Fdrive.google.com%2Fopen%3Fid%3D1oSLW2NB1g5lk3WITtaXzhRk3_wrUbSGu%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdrive.google.com%2Fopen%3Fid%3D1oSLW2NB1g5lk3WITtaXzhRk3_wrUbSGu%3C%2FA%3E%3C%2FP%3E%3CP%3Ehlacomplete%3A%20%3CA%20href%3D%22https%3A%2F%2Fdrive.google.com%2Fopen%3Fid%3D1Lt2t8EDCjh1osydGfJI57BvoQy-px2X6%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdrive.google.com%2Fopen%3Fid%3D1Lt2t8EDCjh1osydGfJI57BvoQy-px2X6%3C%2FA%3E%3C%2FP%3E%3CP%3Ehlaentire%3A%20%3CA%20href%3D%22https%3A%2F%2Fdrive.google.com%2Fopen%3Fid%3D1UKjm9FBuRmnzxcNsQbqX7EP_jd2jpExD%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdrive.google.com%2Fopen%3Fid%3D1UKjm9FBuRmnzxcNsQbqX7EP_jd2jpExD%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20anyone%20could%20help%20me%20out%20I%20would%20be%20most%20appreciative.%20I%20have%20messed%20around%20a%20little%20with%20deleting%20duplicates%20and%20such%20but%20am%20not%20confident%20enough%20in%20my%20abilities.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-293715%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Melissa McDowell
Occasional 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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies