Combining several imported sheets in one QUERY fails
Merging several imported sheets into one QUERY gives parse, array or column-shift errors.
Tier II · Emerging Problems that are still building up.
7 public reports · first reported 1 September 2019 · last reported 23 August 2024
What's going wrong
People who combine data from several identical source files into a single summary table, using a query over several IMPORTRANGE blocks, get formula parse errors, array literal errors, or results where the second source lands in the wrong columns.
AI-assisted: written with the help of AI from the reports. The idea report has the full summary.
In the idea report
- The full summary.
- The products the 7 reports are about, and how many came each month.
- Related problems.
No business has been found with this problem yet, so the report has no contacts. All sales are final — no refunds. Pricing.