Turn columns into rows

KNIME Analytics Platform
1

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

pivot

2

Chiao @Andrea_Roma_77

The solution Iā€™m proposing here is based on grouping and splitting:

image
image812Ɨ515 90.4 KB

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

Hope it helps

Best

Ael

3

WOW!
Thank you!
Just what I needed. :bowing_man:t3:

4

Ciao @Andrea_Roma_77

Felice di sapere che ha funzionato :smiley: :+1:

5

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

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

6

just a slight variation on @aworkerā€™s solution turn columns into rows ā€“ KNIME Hub