Linking two tables

[QAA91]

Program	Task	President	Vice President	Secretary	Treasurer	Academic Affairs	Campus Affairs	International Student Affairs	Club and Sports
ABC	1	John	Lissa	Kilian	Livy	Shane	Miley	Kate	Alice
DEF	2	Kilian	Livy	John	Shane	Kate	Alice	Livy	Miley
GHI	3	Shane	Kilian	Kate	Alice	Miley	John	Livy	Alice
JKL	4	Livy	Shane	Miley	Kate	Alice	Kilian	Kate	John

List of Students Representative Council

John

Lissa

Kilian

Livy

Shane

Miley

Kate

Alice

Hi, how to link this two tables so that when I filter for specific program and task, it can shows me the specific number of students without duplicate. Many thanks. 

[CNENFRNL · Accepted solution]

Simple enough, just unpivot your first table,

[QAA91]

Thank you