Copy and duplicate Rows based on value in cell


Hi there,

I have the issue where a user is attempting to duplicate the cell value within a sheet, based on a trigger, and a quantity.

For example:

Form intake produces a row with the values

Column: Status = "Requested"

Column: Quantity = "3"

Column: CODE = "ABC"

I would like when the Column: Status changes to "Published", it creates an automation to create "3" new rows within another sheet, all with the CODE ABC.

In theory, I would like to expand on this as well, so that not only the CODE will be created as a unique line item based on the Quantity, but other column values can be taken as well.

How can I go about doing so?