Pivot Column in Query

Hey netanel ,

you can just select the "Data Source" Column and then chose "Pivot Column".

In the upcoming dialogue, choose "Sum" as aggregation type for the values:

Then the result will be as you desired:

Check here my example:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8vRT0lEyNFKK1YGxjZHYJkhsUyS2GRLbHMz2Dw0BcSyQOZZIHCMDZI4hMscImQO0PRYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Data Source" = _t, Amount = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Data Source", type text}, {"Amount", Int64.Type}}),
    #"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[#"Data Source"]), "Data Source", "Amount", List.Sum)
in
    #"Pivoted Column"