I have a Google Form where I ask for the specific college someone is studying in (i.e. college of engineering, college of business, etc.) and then send them to a specific question where they select an option from a multiple choice of majors specific to their college.

This form sends responses to a Google Sheets file, which has multiple columns all named "major", but only one is even full because the users only answer the major question specific to their college. I don't want to just have one question where I ask their major because then there would be over a hundred they'd have to sort through. Is there a way to automatically merge these columns into one still named "major"?


1 Answer 1


Choose Insert > Sheet and dynamically copy the data from the 'Form Responses 1' sheet there, using { array expressions } to copy columns that do not require manipulation, and an array formula to copy the major column, like this:

={ 'Form Responses 1'!A1:F }

=arrayformula( 'Form Responses 1'!G1:G & 'Form Responses 1'!M1:M & 'Form Responses 1'!P1:P )

...where the responses to the major question appear in columns G, M and P.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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