Group list field but show grouping by individual value?

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? :slight_smile:
Thanks!

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