Forum Discussion

Cream_17's avatar
Cream_17
Frequent Visitor
2 years ago
Solved

Pivot the table

Hi guys,   I really need your help   I want to change the table (table one) from this one   Column1 1 A B 2 C 3 D E 4 F G 5 H   to this one (table...
Need Help
Show and Tell
  • AlienSx's avatar
    AlienSx
    2 years ago
    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    group = Table.Group(
        Source,
        "Column1", 
        {"x", (x) => x[Column1]},
        GroupKind.Local, 
        (s, c) => Number.From(c is number)
    ),
    z = Table.FromList(group[x], (x) => x, {"No", "Manchester", "Arsenal"})
in
    z
AlienSx's avatar
AlienSx
Super User
2 years ago
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    group = Table.Group(
        Source,
        "Column1", 
        {"x", (x) => x[Column1]},
        GroupKind.Local, 
        (s, c) => Number.From(c is number)
    ),
    z = Table.FromList(group[x], (x) => x, {"No", "Manchester", "Arsenal"})
in
    z
Cream_17's avatar
Cream_17
Frequent Visitor
2 years ago

Oh my God, you are awesome!

Thanks!, it works!