Forum Discussion

problematic111's avatar
problematic111
New Member
8 years ago
Solved

Rows to Columns

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 …...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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"
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

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's avatar
    problematic111
    New Member
    8 years ago

    Works like a charm! 5/5