I have a spreadsheet with student data. For each subject of the same student there is a specific line. I would like to do a mail merge with just one email per student, but I would import the data from all the articles.
Table: First column has the student ID, each student has his / her own. Second and third name and last name respectively. Fourth and Fifth Column ID and name of Matter, and finally in the sixth and seventh onwards the performance of the student in each subject.
Example:
ID ....... Name and Name .......... ID and name matter ...... Access ...... Note 1..n2..n3..n4 > 1234 ..... João Silva ............. 3
Portuguese ............ 28/04 ........... 1 ......... 2 .... 5 .... 4
How do I get all of a student's subjects on a page? Example above, plus Mathematics, Science, Reasoning, etc.