Generating separate rows from a multiple selection in forms

%3CLINGO-SUB%20id%3D%22lingo-sub-2165057%22%20slang%3D%22en-US%22%3EGenerating%20separate%20rows%20from%20a%20multiple%20selection%20in%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2165057%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20form%20(for%20a%20school)%20that%20allows%20teachers%20to%20enter%20data%20about%20students.%20They%20can%20select%20one%20or%20more%20students%20from%20a%20pre-populated%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20a%20teacher%20selects%20multiple%20students%2C%20all%20are%20exported%20to%20excel%20on%20the%20same%20row.%20Is%20there%20a%20way%20of%20generating%20a%20row%20for%20each%20student%2C%20duplicating%20the%20data%20for%20every%20other%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20instance%2C%20the%20teacher%20might%20select%20Jim%2C%20Bob%2C%20and%20Johnny.%20Then%20select%20that%20they%20all%20want%20to%20play%20football%20in%20the%20next%20question.%20I%20would%20like%20the%20resulting%20excel%20spreadsheet%20to%20record%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Column%20A%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BColumn%20B%3C%2FP%3E%3CP%3ERow%201%26nbsp%3B%20%26nbsp%3BJim%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BSoccer%3C%2FP%3E%3CP%3ERow%202%26nbsp%3B%20%26nbsp%3BBob%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Soccer%3C%2FP%3E%3CP%3ERow%203%26nbsp%3B%20%26nbsp%3BJohnny%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BSoccer%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhile%20I%20could%20do%20this%20once%20in%20Excel%2C%20the%20user%20who%20will%20be%20looking%20at%20the%20spreadsheet%20is%20not%20a%20proficient%20user.%20Is%20there%20a%20way%20to%20make%20forms%20export%20to%20excel%20in%20the%20above%20manner%3F%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2165057%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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!

2 Replies

@mfyfield not with Forms on its own, you would need to create a flow in Power Automate but even there dealing with multi-choice questions can get a bit complex.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Cheers @RobElliott - I feared that might be the case. Oh well - I'll just have to get the teachers to enter them one by one. They shan't be happy :)