Forum Discussion

NickDSL's avatar
NickDSL
Icon for Helper I rankHelper I
2 years ago
Solved

Pivoting Columns into one row

I have data like below. Products Date Value 1 1/1/2023 10 2 1/1/2023 10 1 1/2/2023 20 2 1/2/2023 20 1 1/3/2023 30 2 1/3/2023 30 1 1/4/2023 40 2 1/4/2023 ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • AlienSx's avatar
    AlienSx
    2 years ago
    = Table.Pivot(Table.TransformColumnTypes(Source, {{"Products", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(Source, {{"Products", type text}}, "en-US")[Products]), "Products", "Value", List.Sum)
AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
2 years ago
= Table.Pivot(Table.TransformColumnTypes(Source, {{"Products", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(Source, {{"Products", type text}}, "en-US")[Products]), "Products", "Value", List.Sum)