First of all, I've a file which contains data like this :
Kevin, Anne-De-Bretagne Harvard
Jean, School School School School
Basically it just contains a Name and the differents Schools the student has study to.
I need to be able to select a school in a sheet and it will only show the student that have been to this school, but i've no idea how to structure my data model to fit that.
I thought about creating 2 different table one with names and the other with schools but that means i need to write all of the school in the school table and there can be a lot of them for one student.