Forum Discussion

silvias's avatar
silvias
Helper I
4 years ago
Solved

Transpose only two row

HI, I have a table like the following:   ID CARACT VALUE a1 caract1 value1 a1 caract2 value2 a2 caract1 value3 a2 caract2 value4   I would like to transform it into: ...
Need Help
  • jppv20's avatar
    jppv20
    4 years ago

    Hi silvias ,

     

    Go to PowerQuery, select the column Caract and choose Pivot Column.

    Select Value as values column and in the advanced options choose Don't aggregate.

     

    If I answered your question, please mark it as a solution to help other members find it more quickly.

jppv20's avatar
jppv20
Solution Sage
4 years ago

Hi silvias ,

 

Go to PowerQuery, select the column Caract and choose Pivot Column.

Select Value as values column and in the advanced options choose Don't aggregate.

 

If I answered your question, please mark it as a solution to help other members find it more quickly.