I'm using ImportHTML()
on a Google Sheet to import a large table from a website. It's great, and it's now all there, but now I want to hand-modify the data to my needs. Unfortunately, every time I try to make a change all the data goes away and I get a #REF
error in the cell which contained the ImportHTML()
equation.
So, I now have a document with a single ImportHTML()
cell that magically displays all the data from the website. I want to have an array of cells containing fixed data fetched using ImportHTML()
. How can I do this?