Populate a column from a cell from another table

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:

|Col 1|
Liam
Fred
Emily
Ann

Thanks guys.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.