combine rows with columns

[chahine]

Hi all, 

The table bellow has period, attributes, Atucal and Plan columns. the 33 rows correspond to the attributes (picutre1).

I'd like to change table structures: it would have 2 rows that correspond to the period, and 33*2 columns. the colums would be structured as follow:  Attribute1_acual, Atribute1_plan, Attribute2_acual, Atribute2_plan, ..., Attribute_n_acual, Atribute_n_plan

As shown in picture 2.

I spent the entire day but didnn't succed to find a proper solution. therefore I will appreciate your help!

Thank

[truptis · Accepted solution]

Hi @chahine , Try to do Pivot/unpivot this only then it will give you the desired structure that you want(33*2).

[chahine]

Hi @truptis Thank you! it worked after several Pivot/Unpivot