Data Shaping - Pivot

[Martin-Prague]

Hello Experts,

I need to perform following pivot operation in Power Query.

I need to Group the data by Sales Rep and Date/Date and then the rest of the fields should be pivoted as in the following example.

Would you advise me how to it in Power Query?

Thanks a lot,

Martin

[smpa01 · Accepted solution]

#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Added Prefix", {"Rep", "Day", "Place"}, "Attribute", "Value"),
    #"Merged Columns" = Table.CombineColumns(#"Unpivoted Columns",{"Place", "Attribute"},Combiner.CombineTextByDelimiter("-", QuoteStyle.None),"Merged"),
    #"Pivoted Column" = Table.Pivot(#"Merged Columns", List.Distinct(#"Merged Columns"[Merged]), "Merged", "Value")
in
    #"Pivoted Column"

These three steps will generate the output.

[Martin-Prague]

Amazing!