power query rows to columns

[adamelston]

Hello, please could you let me know how to change selected rows to columns in power query (Office 19). I would like to keep w and value as row but move x y z and associated values to columns.
Many thanks.
A

Column1	Column2		Column1	w value	x	y	z
w	1		w	1	2	3	4
x	2
y	3
z	4

 

[sandy666]

try

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    IF = Table.AddColumn(Source, "Custom", each if [Column1] = "w" then "w" else "w"),
    Pivot = Table.Pivot(IF, List.Distinct(IF[Column1]), "Column1", "Column2")
in
    Pivot

or

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    w = Table.AddColumn(Source, "Custom", each "w"),
    Pivot = Table.Pivot(w, List.Distinct(w[Column1]), "Column1", "Column2")
in
    Pivot