Transpose or similiar

[emilie272]

Hello!

I’m still new in knime and struggling…

I have a table (about 4000 lines) which has one column, it is a regroupement of item id. I also have the rowid. Example of the table:
Row1 A12;A1;A14;A19
Row2 A29;A92;A2;A4;A12
etc.

I want to have something like that at the end:
A12 Row1 Row2
A1 Row1
A14 Row1
A19 Row1
A29 Row2
A92 Row2
etc.

How can I do that? I was thinking about spliting the cells, then doing a loop to merge with another table I have (the list of all items id). But I was wondering whether there is an easier way to go. Transpose sounded good to me but it didn’t work.

Thank you very much for your help!

[izaychik63]

Look at Unpivot example

Unpivot Example – eric4781cool

[Daniel_Weikert]

@izaychik63 pointed you in the right direction.
For future questions it is always helpfull to attach a sample dataset (excel, csv,…)
br

[emilie272]

Thank you very, unpivot was the answer. Noted for the sample dataset.