So like my title states I would like to select via a Query only the rows where certain cells are not blank/empty.I have 4 pools that I have a form for collecting their chemistry.  In separate sheets I would like to display each pools data.I'm expecting some incomplete submissions but if I get just one value I would still like to get it, however I dont want any where that pool values are completely empty.This is the query that I thought might work however I only get the headers.This is the example sheet anyone can work on.=QUERY('Form Responses 1'!A:N,SELECT C,E,G,H WHERE G !='' OR H !='' ORDER BY C, E ASC, 1)ORDER BY doesn't work either.  Am I missing something?
Google Sheets Query Get Row When Any of These Cells are Not Empty
google spreadsheets;google spreadsheets query
Please try:  =QUERY('Form Responses 1'!A:N,SELECT C,E,G,H where G is not null or H is not null order by C,E)