Translate multi-select items to individual lines

Hello,

I am trying to determine if the functionality exists to take data generated through a form, with a multi-dropdown, to then take each value selected and create a separate line output? We run samples for analytics and sometimes the same sample gets run on multiple analytical techniques. I would like for only one form to have to be submitted where they select all the techniques they need run; however; in terms of the processing end it is easier to have a separate line item for every test that is being run. Is this possible to do? It would be highly beneficial to not have to submit three forms.

Smartsheet current output:

Desired Output:


«1

Answers