QUERY multiple ranges in Google Sheets

[user172131]

this won't work can you help?

=QUERY('Unsorted RdsdsRdds'!A2:J & 'Unsorted 2sa32'!A2:F"select * )

 

[6StringJazzer]

There is no built-in function called QUERY. Tell us more about what you are doing.

Explain what "won't work" means. What result are you expecting and what result are you getting instead?

The syntax is invalid. You have an unmatched " and may be missing a & symbol as well. What is supposed to be the result of the expression inside the parentheses?

And please give at least a little thought to your title.

 

[MARK858]

There is no built-in function called QUERY

Hi @6StringJazzer, the QUERY function that the OP is referring to is a Google sheets function and not an Excel function (the OP started a duplicate thread where I asked them if it was a Google sheets function they were trying to get an answer for).
I hope this clarifies the question a bit.

 

[6StringJazzer]

Thanks @MARK858. Also a good title would help

 

[MARK858]

Also a good title would help

Anything mentioning Google sheets would have been a help in this case luckily I knew that Google sheets had a QUERY function and I hadn't long glanced at this thread when the OP posted the duplicate (now locked by a Moderator) thread.

 

[RoryA]

You can do something like this:

=QUERY({'Unsorted RdsdsRdds'!A2:J;'Unsorted 2sa32'!A2:F},"WHERE Col1 <>''")

the WHERE clause is to avoid returning all the blank rows specified in your ranges.