Hi everyone, I know it’s probably a silly question but here I go.
Table 1 ‘Classes’ has ‘Class name’ in col1 and ‘Enrolled Students’ in Col2. (All the enrolled students are listed into 1 cell and automatically populated from the Students table where we indicate which class they’re enrolled in).
| ACTING CLASS | [Liam] [Fred] [Emily] [Ann] |
So far so good.
How do I create a new table for each class where the first column (or second column, doesn’t matter) displays automatically the names of the students enrolled on that class such as: