Can i use 'importrange' in google sheets to merge multiple worksheets?

Bouncer5Bouncer5 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.

Comments

  • tealadytealady Posts: 26,262
    Forum Member
    ✭✭✭
    Based on what you are describing, you need to use a database.
Sign In or Register to comment.