Search code examples
google-sheetsgoogle-sheets-formulagoogle-sheets-query

Query across multiple columns within one sheet

I am currently working to build a query from a Google sheet that will allow me to grab data from two different ranges of cells, my example is below:

=query('Form Responses'!A2:F,G2:G "Select * Where F='Yes'")

This does not work...

I want to grab data from A2:F AND G2:G within the same sheet, Form Responses.... how do I go about doing that?

Solution

  • you need to do it like this:

    =QUERY('Form Responses'!A2:K, "select A,B,C,D,E,K,G where F='Yes'")