Column to Row help

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

what is now
1-1

what I want to happen

Unpivoting doesn’t work as I need it to

What about

node?

2 Likes

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.

2 Likes

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.