Help

Populate a column from a cell from another table

541 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Loic_Valmy
4 - Data Explorer
4 - Data Explorer

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.

0 Replies 0