Forum Discussion

Aaron22's avatar
Aaron22
New Member
4 years ago
Solved

Column Header to Column value

Hi i am new in power bi How to convert the column header to column value ex, Table1 ColumnA | ColumnB | ColumnC data1       | data2      | data3 Table2 Column1  ColumnA ColumnB ColumnC  
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Aaron22 ,

     

    The dummy data you provided is easy to convert.

    Select three columns and then click 'Unpivot Columns'.

    The column headers are converted to the column values.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Aaron22 ,

 

The dummy data you provided is easy to convert.

Select three columns and then click 'Unpivot Columns'.

The column headers are converted to the column values.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.