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"?