I have a response sheet on GSheets with over 100 columns/questions that can either be responded by Yes or No. If the candidate answers no they will have to fill in a freetext question.
The following formula - allows me to export the questions that were answered Yes or No from one sheet to another:
=QUERY('Module 1 Responses'!$A$2:$AS,"SELECT "&join(",",arrayformula(SUBSTITUTE(ADDRESS(1,MATCH($A$1:$W$1,'Module 1 Responses'!$A$1:$AS$1,0),4),1,""))))
I would like to add an "if" or a "filter" clause to this formula so that I can only see the "No"s or that would convert all the "Yes" values to blank - if at all possible