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
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
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
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
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
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.
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
Links doesn't work.jmatthewschan wrote: ↑Mon Jan 31, 2022 8:22 amhttps://www.excelforum.com/attachment.p ... tid=765773
https://www.excelforum.com/attachment.p ... tid=765774
Urgent Questions shoot here: khnaz35@gmail.com
Enjoy nature
@johnp and @khnaz35
Here is the working link for the two screenshots.
https://flic.kr/s/aHBqjzAQi5
Thanks,
John
Here is the working link for the two screenshots.
https://flic.kr/s/aHBqjzAQi5
Thanks,
John
Who is online
Users browsing this forum: No registered users and 106 guests