I have a query formula setup to pull form data from another sheet in the same spreadsheet. For some reason, it is loading all the rows but in one row.
Went ahead and made a copy of my spreadsheet so the issue can be seen better
CodePudding user response:
Instead of query
you can use IMPORTRANGE(spreadsheet_url, range_string)
function:
For example if you create a new sheet and copy this formula to A1, then you'll have the range from your current sheet in the new one:
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iCIfdA7lg6DNzr6O-q7oLWeXCFgTxbrwBi4wYqR7hQw/edit#gid=294335694", "A:C")