Showing the content of two columns of the same table in one list using SELECT

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 - 4, Nick - 5, Derek - 2}

Thank you.

Concatenate the values into a 3rd column in the Teachers table, then just run one select on that new column.


Of couse! It’s so simple.

Thank you so much.

1 Like