Creating rows from existing columns

Hi!

I have I have a file to clean up and it has multiple columns: Product Code, Linked Product Codes, Style Number etc.

Both the Product Code and Linked Product Code refers to the same style, they have the same attributes ( all the other columns following those columns are exactly the same).
I want to paste all the Linked Product Codes as separate rows ( the linked product codes to become product codes on their one), and to be followed by the same attributes ( columns) as before.

I have made an excel with the workaround ( see table 2).
Any ideas how it can be done?

Thanks!

Screenshot 2023-04-06 at 18.24.01.png

Datasets

Developer Tools

Tips and Tricks

Custom Tools

Macros

Transformation

Help

Preparation

Optimization

Accepted answers

SPetrie

If I understand this right, I think a select and a union tool are all you need.

Use the select to remove the product column and rename the linked column and then union that back in.

All comments

SPetrie

If I understand this right, I think a select and a union tool are all you need.

Use the select to remove the product column and rename the linked column and then union that back in.

Yoshiro_Fujimori

If you don't need the old column ("Linked Product Code") any more, Transpose tools may come in handy.

Input

Workflow

Transpose Tool Configuration

Output

Transpose.yxmd

SeanAdams

There's a few other options:
- filter product & linked products (using a select tool) - and then union them into one data set - and then look for distinct by using the unique tool.

- you may be able to use the Arrange tool - this is one that doesn't get as much love as you'd expect - it's under Transpose

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703