Messy form data -- how to make it useable

I need the % of students who liked or did not like each food they tried, by class and as a whole. (They leave blank if they did not try one.) Any suggestions?
I have Student 1-4 in each class, which is a problem. I do have real names to tie to Student 1 (Teacher ) AA, etc. on the ID sheet.
6 foods. 4 teachers. 4 Students per teacher for this sample.
Thanks for looking.

Hey there!

Take a look at Tidy data • tidyr. I'm sure that 20 min of reading this article and an investigation of pivot_longer command will do the trick :ok_hand:t2:

Best of luck!