All Questions
1 question
1
vote
1
answer
4k
views
How to simplify "IS NOT NULL" for multiple columns when using QUERY function in Google Sheets?
I have this formula:
=QUERY(
{AG4:AW101},
"Select Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8, Col9, Col10, Col11, Col12, Col13, Col14, Col15, Col16, Col17
where Col1 is not null
...
- 555