Is there a Reverse Summarize or De-Summarize function!

[RevenueMonkey]

I have a table which summarizes product price and frequency. I wish to perform a number of statistical functions on the table, such as average, standard deviation and wish to use some visuals that require the data in a single coloum de-summarised: - How do I best do this?

Current table:

Price, Frequency

12.99, 3

4.50, 1

8.95, 3

Desired column:

12.99

12.99

12.99

4.50

8.95

8.95

8.95

[CNENFRNL]

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTSs7RU0lEyVorViVYy0TMFsg3BbAs9S1OIRCwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Price = _t, Frequency = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Price", type number}, {"Frequency", Int64.Type}}),

    Repeated = Table.CombineColumns(#"Changed Type", {"Price", "Frequency"}, each List.Repeat({_{0}}, _{1}), "Price"),
    #"Expanded Price" = Table.ExpandListColumn(Repeated, "Price")
in
    #"Expanded Price"

[RevenueMonkey]

Thank you, because my expertise in Advance Editor is limited. Can the answer be simplified and expressed as individual Power Query steps? or as a New Measure in PBI using AverageX perhaps?

[RevenueMonkey · Accepted solution]

Scratch that, I've fiddled with Advanced Query and got it work. Thank you for your swift eligant solution.