Group list field but show grouping by individual value?

[Samir_Ghosh]

Hi,
I see similar questions posted and I think seem to be to do joins because it’s more powerful. However, sometimes you want ease over power.

Is there any way to display the two records in ONE TABLE:

1. John, Blue & Red [list]
2. Jane, Red & Green [list]
   as
   Blue: John
   Red: John, Jane
   Green: Jane

WITHOUT JOINS? :slightly_smiling_face:
Thanks!

[Danna_Redmond]

Did you ever get an answer to this? I am trying to save the same problem.