4 Replies Latest reply: Aug 1, 2018 8:44 AM by Youssef Belloum RSS

    Table Creation

    Vincent Bellanger

      Greetings,

       

      I need enlightements on some basics.

      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.

       

      Thanks for all the answers/advice !