I have a view that lists users. These users have skills. Two users are listed multiple times; one user three times; twice with "no skill" and once with the skill they have; another one twice, once with "no skill" and once with the skill they have. If I enable aggregation, skills are gone; if I don't, I get duplicate results. I have tried distinct as well, to no avail. Please see the screenshot below.
What can I do to eliminate this issue?