Views relatonship with multi value field - and views distinct I have a View that shows a list of Classes (nodes) and the relevant Teachers (Users) on my system. It is designed to show one class per table row and then a comma seperated list of the users who belong to this class.

As my "relationship" in the View is a user reference field (multi valued) then I get a list of Classes and teachers names next to them (as this uses the relationship to find Profile2 fields of First Name, Surname etc). But it causes duplicate nodes. I have tried using Views Distinct but you can see what happens below. I can get rid of the duplicates but it doesn't give any way for me to have a comman seperated list of my rewrote ouput of Users.



In my example there are 3 users referencing "Year 2" but when I try to eliminate the duplicates - it only shows one teacher next to that class. Is there a way around this duplicate, multi valued, relationship issue in Views?
use group-by class so it will show you unique class name with teachers for the class