Change Table

[Syndicate_Admin]

Hello, everyone!!

How can i change table A to table B with Power Query???

[AlienSx]

Hello, PQ21

let
    Source = TableA,
    group = Table.Group(Source, {"Column1"}, {{"columns", each _[Column2]}}),
    z = Table.FromColumns(group[columns], group[Column1])
in
    z