Column Header to Column value

[Aaron22]

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

[v-stephen-msft · Accepted solution]

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.

[Vijay_A_Verma]

In a blank query, put following in Formula bar

= Table.FromList(Table.ColumnNames(Table1))