Distribute nested values over rows

Simplify your

In the community an interesting solution was provided by Micah Lucero for what seems to be a complicated problem. You have per cell multiple values and you want to distribute them over new rows in a target table, while keeping the link with a unique identifier like the row Id or the creation moment. By the way, both are numbers.

I have seen the need for this logic in product domains, like the sales via Shopify. Or in a Bill Of Material logic when an item is sold, you want all related items taken out of your stock. In the community the question was about work tickets. They all share the idea that multiple parts or items are living together in a single cell.

The provided solution by Micah Lucero is concise and elegant and worthwhile your consideration in case you come across a comparable challenge. What he offered is based on the insights of Coda you find here.

We evaluate this code snippet in 3 parts.