IMPORTJSONAPI
IMPORTJSONAPI copied to clipboard
Split no header data into multiple rows
Is there a way to split data into multiple rows. I see that the column function can print to the line adjacent can this be standardized in some manner? Currently data only goes into a single cell.
This is what I have so far:
=IMPORTJSONAPI("https://api.coingecko.com/api/v3/coins/alephium/market_chart?vs_currency=usd&days=max&interval=daily", "$.prices","@,[2]", doNotDelete!B1)'