Transposing Automatically

[vonmunchy]

Candle Test.JPG

i have a large data set. its just prices im collecting from a Jason script copy pasting, but when i copy them i get all the data as below shown above.

{
"candles": [
{
"close": 10607.2,
"epoch": 1647132360,
"high": 10607.2,
"low": 10588.92,
"open": 10591.48
}

How can i easily get all the close, epoch, high, low, open with its respective prices as cloums?

i attached a sample excel file as well.

Thank you

[XOR LX]

Hi,

=LET(α,B3:B700,INDEX(FILTER(α,α<>""),SEQUENCE(COUNT(α)/5,5)))

Regards

[Czeslaw]

Formula

Please Login or Register  to view this content.

[vonmunchy]

apologies for the late reply. Thank you for the solutions