Transpose Data using PowerQuery

[rileybloke]

Hello,

I have data like this...

Key	p1	p2	p2	p3	p4	p5	p6	p7	p8	p9	p10	p11
TRB01201401	25	34	353	45	35	543	543	5434	5434	43	44	34
TRB01201402	423	53	34	434	5	5	4	5	5434	2	4	3

<tbody>
</tbody>

I need to transpose it within PowerQuery so that it looks like this....

Key	Period	Amt
TRB01201401	P1	25
TRB01201401	P2	34
TRB01201401	P3	353
etc etc etc

<tbody>
</tbody>

I have played with many of the functions, but haven't been able to achieve it, any advice or guidance would be great thanks.

 

[theBardd]

PQ has an Unpivot function (in the Transpose tab), using that and renaming the columns gives the following M code

let    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {"Key"}, "Attribute", "Value"),
    #"Renamed Columns" = Table.RenameColumns(#"Unpivoted Columns",{{"Attribute", "Period"}, {"Value", "Amt"}})
in
    #"Renamed Columns"

 

[rileybloke]

Bingo! thanks