Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Change Table

  Hello, everyone!! How can i change table A to table B with Power Query???
AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
3 years ago

Hello, PQ21

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