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