I’m trying to build a google sheet which imports the order history for a region for a bunch of items. I can import the data using a function and the function returns the data in an array of multiple rows and columns for each item.
The problem I’m having is that the data wont expand because when i use the autofill dragging, the subsequent functions are blocking where the data needs to expand, so I just get the error thrown up in the picture. I know I have to leave enough space between each function so the arrays can expand, but I do not know how to do this other than manually, which is not ideal since i need a few hundred of these arrays.
So is there a way that I can autofill the sheet so that there is enough spacing between the functions so that the arrays will expand?