Turn columns into rows

[Andrea_Roma_77]

Hello.
I need to turn columns into rows by pivoting on the ID column.
Which NODE do you recommend and how should it be customized?
Thank you

[aworker]

Chiao @Andrea_Roma_77

The solution I’m proposing here is based on grouping and splitting:

20220218 PIkairos Turn columns into rows.knwf (34.9 KB)

Hope it helps

Best

Ael

[Andrea_Roma_77]

WOW!
Thank you!
Just what I needed.

[aworker]

Ciao @Andrea_Roma_77

@Andrea_Roma_77

WOW!
Thank you!
Just what I needed.

Felice di sapere che ha funzionato

[Daniel_Weikert]

I borrowed @aworker great solution as source an used the following way

Always great to learn various ways for me. Thanks for sharing @aworker

[duristef]

just a slight variation on @aworker’s solution turn columns into rows – KNIME Hub