I've created a form for my staff to enter metrics about their job so I can track how new operations affect their output. For the ease of my staff, I'm hoping that they can submit multiple responses per question (long answer text), instead of doing multiple entries for staff person.

On the response side, I've figured out how to split these results, but I'm hoping to have run as a query and don't know how to have additional rows added as needed based on the multiple responses for one entry?

So for this example enter image description here there would be three rows generated based on column C

Your Answer

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

Browse other questions tagged or ask your own question.