I am able to fetch data from multiple URL's listed in a single column in google sheets using importhtml/importxml formula. However, when I drag the column with the formula it overwrites the existing data of the previous results. The error that I get is Array result was not expanded because it would overwrite data in the C4.Here is a live example to test:: https://docs.google.com/spreadsheets/d/1eFrLYk9T7mNUGRRFpcP_dP0v6tptDZCPTzGdAe4RVlM/edit?usp=sharingSheet1 contains the formula and error I see. (cell - C3,C4,C5)Sheet2 is the desired output using importxml/importhtml formula.How can obtain the desired result for 100+ URLs using a formula?Thank you in advance.
ImportXML shows Array result was not expanded because it would overwrite data in the C4 Error
google spreadsheets;google apps script;google spreadsheets query