Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Change Table

 

Hello, everyone!!

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

1 Reply

  • AlienSx's avatar
    AlienSx
    Super User
    2 years ago

    Hello, PQ21

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