Splitting records with 2 or more multiple-select options into individual records in a new table

[electricli]

I have a table of projects. Associated with each project is multiple teams and multiple quarters. Both the quarters and teams fields are sourced from linked records.

I would like automation (or script) to create related projects in another table, one per multiselect field combination. I've tried creating a script with ChatGPT, but no luck. I also so some other solutions in the community that were similar, but not quite the same as my situation. Any suggestions?

[TheTimeSavingCo · Accepted solution]

What issues did you face when attempting to use repeating groups for this?

https://support.airtable.com/docs/repeating-groups-of-automation-actions

[electricli]

The repeating groups helped, but I can only apply it to one field (I can't nest them). For now, this will work. Thanks!