Generating separate rows from a multiple selection in forms

I have created a form (for a school) that allows teachers to enter data about students. They can select one or more students from a pre-populated list.

When a teacher selects multiple students, all are exported to excel on the same row. Is there a way of generating a row for each student, duplicating the data for every other question.

For instance, the teacher might select Jim, Bob, and Johnny. Then select that they all want to play football in the next question. I would like the resulting excel spreadsheet to record:

            Column A       Column B

Row 1   Jim                 Soccer

Row 2   Bob                Soccer

Row 3   Johnny           Soccer

While I could do this once in Excel, the user who will be looking at the spreadsheet is not a proficient user. Is there a way to make forms export to excel in the above manner?

Thanks!