I’m not sure if I’m asking this the right way but I hope it’s clear.
I made a form and collected results where each student selected all the periods they are free each day. So on my results table I have a column with names, and then a column for each day of the week which contains the list of all the free periods for that student. For example, for the Row for student A, the Monday column may have periods 2,3, and 4 listed if that’s what they selected from the select list, and Tuesday might have periods 4 and 7.
Now I want to work with that data and see which free periods Student A, B, and C, all share. Is there a way to do this?
If not, perhaps I can sort the results so I can see a list of the names of all people are free at a specific period that day. Is there an easy way to view that?