How best to create a matrix of the person assigned in a list like this:
I assume a pivot but since the names are together it is not quite so apparent how to best display the info per person.
Owner Qstn No
Jenn Jett 1.
Jenn Jett, Martin 3.
Martin, Anne 4.
Martin, Anne 5.
Martin, Lars, Chris Isaac, Linda Cuny, Anne 6.
Please see the attached.