Use of Pivoting or Unpivoting

[ARock1980]

Hi all, I have a simple question about the application of the pivot node (if this node is the right one…) and its correct use with an example.

In the file “Pivot - Input Table” the entries are arranged crosswise. My wish is to rotate them (see picture) and Create Column A with Name “Periode”.

Input Table
Pivoting.xlsx (10.9 KB)

Output

Thanks in advance

[tommy]

hi @ARock1980,

what you need is the Unpivoting — NodePit

It should be configured like that…

Afterwards you may rename the columns and filter them.

best regards, Tommy

[ARock1980]

Hi @tommy, thanks for your quick reply and your help with my first steps with Knime