Hi, everyone. I have two lists using SELECT:
SELECT(Teachers[Name],[Name]<>[On Leave]) → {James, Nick, Derek}
SELECT(Teachers[Number of Periods],[Name]<>[On Leave]) → {4, 5, 2} Is
there a way to join the content of the two to look like this? {James -...