I'm using ImportHTML to pull in data scraped using another tool called Import.io, as you can see in the example spreadsheet here.However, when I pull in data using ImportHTML, it's pulling 3 years of data into 1 cell, so 1 cell contains the column heading and 3 years of financial data. I want to break out the 3 numbers in each cell so that there is only one number per cell, but can't seem to figure it out. I've tried splitting the data, trimming it then splitting it, converting using =Value(), but can't get the data into its own cell. Would love help from the community.Example spreadsheet here.
How to split multiple values in one cell into separate cells?
google spreadsheets;google drive