Changing structure of a pivot table

Hi, I have a table in the following format:

account number FC_Product1 FC_Product2 FC_Product3 FC_Total LC_Product1 LC_Product1 LC_Product1 LC_Total Total
1 sum(FC_Producr_1,FC_Product_2, FC_Product3) sum(LC_Producr_1,LC_Product_2, LC_Product3) sum(FC_Total, LC_Total)
2
3
4
5
Total

and need to change format to this one:

account number Product_1 Product_2 Product_3 Total
1 FC
2 FC
3 FC
4 FC
5 FC
1 LC
2 LC
3 LC
4 LC
5 LC
Total

Can anyone show me how I can do it? Many thanks in advance!

Hello @Skirpichnikova_Ksenia,

you should use Unpivoting node. Sums are your value columns, while account number (and all other you would like to keep) are you retained columns.

Br,
Ivan

1 Like

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