Help with formatting multi select grouping


Hi! New user of Airtable.

I have a series of products. Some are bundled together. Some are in multiple bundles.

I set up a sample table to show what I mean.

So I have products A-I.

Product E is a bundle of products A, B, C, and D.

Product F is a bundle of products A and B.

G, H, and I are just plain stand alone products.

I want to be able to group by bundle so that product A shows up in both bundles when looking at a grouped view.

Here is the sample table that I set up to mimic my actual table:

Thanks so much!


You need a junction table: