I am using a form in order to collect information about different pupils in a school. The idea is that each "tutor" needs to complete the form for any students that have obtained more than 2 signatures in an achievement card.
I have chosen to use the list item, as I need to tutor to be able to add additional boxes depending on the number of pupils they need to add, before submitting the form. An example of my form is here:
This works fine. However when I then export the form to CSV in order to calculate stuff in Excel it produces output in the following format:
The problem is, is that each pupil is not in their own row of the CSV and therefore calculations are then made difficult. What I need is for the form to output in the following way instead:
Is there any way to do this? Or am I going about this the wrong way and there is a better way? Would gratefully appreciated any help. Thanks in advance.