I have a table with projects and a linked table with tasks. The projects are usually linked with multiple tasks. Now when I group my projects by tasks, it does not group by each individual task, instead it groups by every list of tasks one project has. This is very cumbersome.
It looks like this:
Group 1: “task1, task4”
Group 2: “task1, task2, task3, task4”
Group 3: “task2, task3, task4”
Group 4: “task3, task4”