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.
Solved! Go to Solution.
Concatenate the values into a 3rd column in the Teachers table, then just run one select on that new column.
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.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |