Transpose table titles from columns to rows

[Anonymous]

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   ; Value1

Value2   ; Value2   ;Value2    ; Value 2

To :

Title 1 ; Value1 ; Value2

Title 2 ; Value1 ; Value2

Title 3 ; Value1 ; Value2

Title 4 ; Value1 ; Value2

I have checked in power BI without success , please let me know if there is any solution to this .

Thanks in advance 

Ismail

[jmelcarek]

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

[Anonymous · Accepted solution]

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

[rlsmith1994]

This solution doesn't make sense. The person just wants to transpose the visualization. Transposing the rows/columns in the editor will change the structure of the data.

[Anonymous]

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]

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