Users don’t get useful results when they group by multi-selects, array based, or comma separated values. In the example below, three recipes that include “Apples” end up in different groups. Whereas a new user might have wished all of the records were listed under “Apples” and then re-listed under other fruits as well.
Honestly, there might not be a good solution without breaking core Airtable functionality and database best practices. In other words, by introducing (gasp) duplicate records as described above. I’m imagining a toggle under the grouping menu where a setting section named something like “split lists & display duplicate records” could display extra records (with an option to set a deliminator). Might also be nice to have a visual indication within the grid when a record is a duplicate.
So the above list would instead look like:
Apples: Apples & Caramel Fruit Salad * Fruit Smoothie * Pears: Fruit Salad * Bananas: Fruit Smoothie *
A user could just filter a view by a group category (such as Apple), but this becomes cumbersome at scale. Or someone could write a script and print customized values to a table, but this isn’t ideal if you were grouping in order to more easily edit live data.