splitting multi value column in query editor

[shubri]

Hi all, pretty much new here, tried searching for an aswer for this. I got query from http://api.bitcoincharts.com/v1/weighted_prices.json and it gives me a table like one in the picture. I would like column values to separate by columns keeping headers 7- 30 and 24h,

What did I miss, I keep getting errors when trying to unpivot/split?

[MarcelBeug · Accepted solution]

The timestamp value can't be expanded, so I would suggest to delete it.

let
    Source = Json.Document(Web.Contents("http://api.bitcoincharts.com/v1/weighted_prices.json")),
    #"Converted to Table" = Record.ToTable(Source),
    #"Filtered Rows" = Table.SelectRows(#"Converted to Table", each ([Value] <> 1511644685)),
    #"Expanded Value" = Table.ExpandRecordColumn(#"Filtered Rows", "Value", {"7d", "30d", "24h"}, {"7d", "30d", "24h"})
in
    #"Expanded Value"