Column to Row help

Help convert the table from columns to rows. There are more than 1000 such columns.

what is now

what I want to happen

Unpivoting doesn’t work as I need it to

What about



Hello @pnovikov. First of all: Welcome to the world of KNIME.

The pivot does always a grouping by the values of one column and typically some calculation (e.g. sum) on another column.
So the unpivot does just the way back but without redoing the math.

The correct node is - as mentioned by @izaychik63 - the transpose node.


Big thanks @izaychik63 and @knimediger!

Transpose this is the way out

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.