Rows to Columns

[problematic111]

Hi,

i've been looking for solution for some days and not yet succeeded. Task is simple, or atleast it should be:

This is what i have:

place_ID	tag
1	X
1	Y
2	X
2	Y
…	…
1900	X
1900	Y

This is what i want:

place_ID	tag X	Tag Y
1	X	Y
2	X	Y
…	…	…
1900	X	Y

I need this to be done at Query editor.  Thanks!

[Zubair_Muhammad · Accepted solution]

@problematic111

Give this a try

File attached as well

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"place_ID", Int64.Type}, {"tag", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"place_ID"}, {{"AllRows", each _, type table}}),
    #"Added Custom1" = Table.AddColumn(#"Grouped Rows", "Custom.1", each Table.Transpose(Table.SelectColumns([AllRows],"tag"))),
    #"Expanded Custom.1" = Table.ExpandTableColumn(#"Added Custom1", "Custom.1", {"Column1", "Column2"}, {"Column1", "Column2"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded Custom.1",{"AllRows"})
in
    #"Removed Columns"

[problematic111]

Works like a charm! 5/5