I want to grab some lists of data from various pages on the web and I'm using IMPORTXML to do it.Assume I have a list of URLs in column D.Depending on the URL, the length of the results can be different and I want to have them all in a single contiguous column.In A1, I've found that the formula={IMPORTXML(D1, xpath);IMPORTXML(D2, xpath)}works for the two URLS in D1 and D2, but I want to be able to pull this off if I have many more URLs listed in the D column. Going to start with about 10 URLs and add more later, and I will do this with more than one xpath for multiple columns to build out a sheet to do lookups on.I'd like to just be able to refer to D:D, and I tried that with ARRAYFORMULA(), for example:=ARRAYFORMULA(IMPORTXML(D:D, xpath))Did not work. I thought that would perform the IMPORTXML for each element in the column. It only included the URL in D1.I'm hoping for a sensible option that won't require that I expand the first formula to keep repeating the IMPORTXML for every row in D, and then as I add URLs later, to have to keep extending the array.
Google Sheets: How can I combine multiple ImportXML results for multiple URLs into a single column?
google spreadsheets;formulas