ah, I see.
So what you have there is essentially a Helper Table.
Okay, so here is what you can do.
- Start by add a RowIndex column (refer to the 2nd use case here)
- Next, add a Query column that targets your Students table, and apply whichever filters you need.
- Add a Lookup column that fetches the Student names via the Query column. This will give you an array of Student names.
- The final step is to transpose that array into a list. Add a Single Value column, target it at the Lookup column, and select X from start, where X is the RowIndex. That should give you a list of Student names, one per row.