Weirdness in views when grouping by a field, and a user has more than one entry in that field I have a view that shows users. Users are associated with an Area in the organization.  The view groups by Area (a vocabulary) and gives a list with nice area headings, with a list of Users inside it.  Unfortunately there is one executive in the organization that is also in charge of another Area, and he needs to appear in both places.  When I assign both areas to his account (entity reference field), we get the following (problematic user in bright blue):



What should happen, is that the blue user should appear once in the Executives area and once in the PMO area.  Instead as you can see, he appears twice in his own special Executives \n PMO area.  It would even be ok, if he only appeared in the Executives area here.  What can I change to get this view to be nice to me?
In your hidden entity reference field's setting in Views, scroll down to Multiple field settings and uncheck Display all values in the same row.

When grouping, the content / user will get shown twice instead of what your screenshot shows.