Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Transpose table titles from columns to rows

Hello ,   I need to transpose a power BI table , please see the example below :   change title position from this :   Title1    ; Title 2   ; Title 3   ; Title 4  Value1   ; Value1   ; Value1 ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi

     

    In Query Editor,

     

    1. Go to Transform -> select option 'Use Header as first row'. So, for your example you will have 3 rows now ,with  Title1..Title4 as first row

    2. Then select Transpose. This will get you desired output with 3 columns & 4 rows. Name the column header as needed.

     

    Thanks

    Raj

jmelcarek's avatar
jmelcarek
Regular Visitor
8 years ago

It needs to be done in the query model.  Go to Edit Queries -> Transform -> Transpose

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello Jmelcarek ,

 

Thanks for the reply , unfortunatey I did not get the correct result , is there any power query that we can use to resolve this issue ?

 

Thanks in advance 

Ismail

  • Weav8060's avatar
    Weav8060
    Frequent Visitor
    5 years ago

    correct, it does work with tables, only with sheets prior to promoting headers.  With table inputs, use this trick formula just prior to transposing step:

    = Table.Combine({ #table(Table.ColumnNames(Source),{Table.ColumnNames(Source)}),Source})

    it creates a first row of your data set with the column names .  There might very well be another way, but transpose functionality is geared to the rows of the table not including column names