Forum Discussion
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
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.
2 Replies
In a blank query, put following in Formula bar
= Table.FromList(Table.ColumnNames(Table1))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.
