Group list field but show grouping by individual value?

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]
    Blue: John
    Red: John, Jane
    Green: Jane

WITHOUT JOINS? :slight_smile:

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.