Advanced Unpivoting Power Query

[hegler23]

[lbendlin]

That is pivoting, not unpivoting.  And it will result in variable number of columns which is something neither Power Query nor Power BI will be happy about.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjbQMzTUMzIwMlHSUQoKDweSpgZAwttdKVZn5EobWSJJe4cHAUlDc9NReazykOCjn3wsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Datum = _t, Benutzer = _t, Menge = _t, ME = _t]),
    #"Grouped Rows" = Table.Group(Source, {"Datum", "ME", "Benutzer"}, {{"Values", each Text.Combine(_[Menge],",")}}),
    #"Pivoted Column" = Table.Pivot(#"Grouped Rows", List.Distinct(#"Grouped Rows"[Benutzer]), "Benutzer", "Values")
in
    #"Pivoted Column"

How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done". Once you examined the code, replace the entire Source step with your own source.

[hegler23]

Vielen Dank für die Lösung

[PwerQueryKees · Accepted solution]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Datum", type date}, {"Benutzer", type text}, {"Menge", type text}, {"ME", type text}}),
    #"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Benutzer]), "Benutzer", "Menge", each Text.Combine(_, ","))
in
    #"Pivoted Column"

[hegler23]

Vielen Dank für die Lösung