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
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?