Forum Discussion
Solved
Linking two tables
| 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.
Simple enough, just unpivot your first table,
