I have created a form that have multiple sections, skipping sections based upon an answer. I have then linked a Google Sheet to this Google Form to collect responses. These responses are auto filtered out into different tabs based upon one answer. Because my form have multiple sections, when it filters into the different tabs, there are blank columns. How can I get these blank columns to delete automatically when it filters into the tabs?


1 Answer 1


Use a query() formula and list the columns you want to see in the select clause.

Alternatively, use a filter() wrapper to filter by columns rather than rows.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.