Can i use 'importrange' in google sheets to merge multiple worksheets?
Bouncer5
Posts: 615
Forum Member
✭✭
Hi there,
I have 20+ worksheets in one google sheet that different people have been working on, all with identical fields, etc. I managed to merge them by having multiple 'IMPORTRANGE' queries in a master sheet, each one referencing a different sheet allowing filtering of certain criteria over the entire dataset.
The problem is when I try to sort the data alphabetically, it stops working because of the multiple queries.
Is there a way to have one longer query that covers multiple worksheets? Something like '=query(IMPORTRANGE("spreadsheet key", "worksheet 1, 2, 3, 4, etc.) and simply pile the data on top itself?
Any help much appreciated.
I have 20+ worksheets in one google sheet that different people have been working on, all with identical fields, etc. I managed to merge them by having multiple 'IMPORTRANGE' queries in a master sheet, each one referencing a different sheet allowing filtering of certain criteria over the entire dataset.
The problem is when I try to sort the data alphabetically, it stops working because of the multiple queries.
Is there a way to have one longer query that covers multiple worksheets? Something like '=query(IMPORTRANGE("spreadsheet key", "worksheet 1, 2, 3, 4, etc.) and simply pile the data on top itself?
Any help much appreciated.
0
Comments