PQ Transpose question

[scott_86_]

Hi,

Using Office 365.

The below snip contains example data for something I am trying to achieve with a much larger dataset.

I'm looking to put the x3 departments as the headers, with names for each department under each header.

Is anyone able to help out with the applied steps or code? Thanks.

 

[AlienSx]

hello,

let
    Source = original_table,
    group = Table.Group(Source, "Department", {"names", (x) => x[Name]}),
    tbl = Table.FromRows(List.Zip(group[names]), group[Department])
in
    tbl

 

[alansidman]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Department"}, {{"Count", each _, type table [Department=text, Name=text]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Count],"Index",1,1)),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Count"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Columns", "Custom", {"Name", "Index"}, {"Name", "Index"}),
    #"Pivoted Column" = Table.Pivot(#"Expanded Custom", List.Distinct(#"Expanded Custom"[Department]), "Department", "Name"),
    #"Removed Columns1" = Table.RemoveColumns(#"Pivoted Column",{"Index"})
in
    #"Removed Columns1"