Forum Discussion
chahine
4 years agoNew Member
combine rows with columns
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
Hi chahine , Try to do Pivot/unpivot this only then it will give you the desired structure that you want(33*2).