Autocrat merge - data in a single row
I am trying to run an Autocrat merge from a google sheet: gr11 reference form.
I have made a tab so that one student can be selected at at a time (select-student-all-data).
But then I think to use Autocrat you need the data in one row?
So I tried creating another tab: Student_Finbarr_data.
This works but only for this one student.
Is it worth me pursuing this way or does anyone know of a better way of filtering the original sheet: Form_responses 1?
Any advice or help much appreciated!
Please note: This is test data only and has been randomly made up.