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 pool's data.
I'm expecting some incomplete submissions but if I get just one value I would still like to get it, however I don't want anywhere 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?