Unpivoting (correct configuration)

[ARock1980]

Hello all,

enclosed a question about the “unpivoting” node and configuration.

I have the following table:Unpivoting.xlsx (9.4 KB)

I want this result:

I use the following configuartion:

Probably it’s a beginner’s mistake Anyway, thanks for your support!

[ipazin]

Hello @ARock1980,

seems you are looking for Pivoting node

Regarding configuration - you don’t have grouping columns, pivoting column is Period and and First aggregation on Volume. Plus for Column name choose Pivot name to have intact period names.

Br,
Ivan