Hello,
I've just not been able to find a solution to this.. I need to create a seperate table merging text based on key (SKU). Please see this example, the table on the left is source. And the one on the right handside is merged text.
Basically it merges text based on SKU (key), and ignores duplicates. Text is then separated by pipe.
How can I achieve this? (Office 365 on Mac, but also has access to Excel on Windows via VM).
Many thanks!
I've just not been able to find a solution to this.. I need to create a seperate table merging text based on key (SKU). Please see this example, the table on the left is source. And the one on the right handside is merged text.
Basically it merges text based on SKU (key), and ignores duplicates. Text is then separated by pipe.
How can I achieve this? (Office 365 on Mac, but also has access to Excel on Windows via VM).
Many thanks!
Product Code | Colours | Sizes | SKU | Colours | Sizes | |
SKU1 | Red | S | SKU1 | Red|Yellow | S|M|L|XL | |
SKU1 | Red | M | SKU2 | Blue|Red | XS]S|M|L|XL|XXL | |
SKU1 | Red | L | ||||
SKU1 | Yellow | S | ||||
SKU1 | Yellow | M | ||||
SKU1 | Yellow | L | ||||
SKU1 | Yellow | XL | ||||
SKU2 | Blue | XS | ||||
SKU2 | Blue | S | ||||
SKU2 | Blue | M | ||||
SKU2 | Blue | L | ||||
SKU2 | Red | M | ||||
SKU2 | Red | L | ||||
SKU2 | Red | XL | ||||
SKU2 | Red | XXL | ||||