Post by jmatthewschan » Wed Jan 26, 2022 11:40 am

Hello Everyone,

I have 2 spreadsheets that I need to combine into one. They have multiple different columns but have one column (SKU) in common. The challenge is that one file (call it A) has one of each SKU, but the second (B) has up to 6 rows of the same SKU.

How can I combine these 2 documents so that the SKU's all line-up?

Thanks,

John

Newbie

Posts

Joined
Thu Jul 01, 2021 2:42 am

Post by johnp » Wed Jan 26, 2022 8:56 pm

What number of items? Tens, hundreds?

Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk


User avatar
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

Post by khnaz35 » Wed Jan 26, 2022 10:23 pm

How about you create one more sheet? Call it C and then mention all the columns into it and bring data to one sheet. Use some filters to find duplicates and also note there is only one column for SKU, not 6.

Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature ;) :) :-*


User avatar
Active Member

Posts

Joined
Mon Aug 27, 2018 11:30 pm
Location - Malaysia

Post by jmatthewschan » Mon Jan 31, 2022 8:22 am

Hey @johnp and @khnaz35, thanks for responding.

There are 80,000 rows with about 50,000 SKU#'s. I don't know if I need a macros or if I need to import using specifically defined filters or if there is some other way to accomplish my task. I welcome any and all ideas!

Basically on the second screenshot I need to merge E2-E7 into one cell with the contents divided by "//". Then I need E8-E10 to also merge and be separated by "//". This is so that each SKU will be contained in one row instead of several and I can combine it with the spreadsheet in screenshot one.

I then need rows 3-7 and 9-10 to completely delete after the above merge is complete.

Given the number of line items, doing this manually is completely unrealistic. Thanks again for your help everyone.

Edit (fixed the screenshot link url): https://flic.kr/s/aHBqjzAQi5

Best,

John
Last edited by jmatthewschan on Wed Feb 02, 2022 9:26 am, edited 2 times in total.

Newbie

Posts

Joined
Thu Jul 01, 2021 2:42 am

Post by johnp » Mon Jan 31, 2022 5:52 pm

Your images are not showing.

Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk


User avatar
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

Post by khnaz35 » Mon Jan 31, 2022 9:49 pm


Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature ;) :) :-*


User avatar
Active Member

Posts

Joined
Mon Aug 27, 2018 11:30 pm
Location - Malaysia

Post by jmatthewschan » Wed Feb 02, 2022 9:24 am

@johnp and @khnaz35

Here is the working link for the two screenshots.
https://flic.kr/s/aHBqjzAQi5

Thanks,
John

Newbie

Posts

Joined
Thu Jul 01, 2021 2:42 am
Who is online

Users browsing this forum: No registered users and 42 guests