Forum Discussion

chahine's avatar
chahine
New Member
4 years ago
Solved

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).

2 Replies

  • truptis's avatar
    truptis
    Icon for Community Champion rankCommunity Champion

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