How can I split info from cells to rows?


I have a sheet set up that is populated by a form. The form will have 2 questions where the user can select multiple options. When that info is captured on a sheet, how can I set the sheet up to parse the multiple pieces of info in each cell to an individual row?

The information comes in from the form like this.

And I want it to be split like this.

Best Answer