Separating Dropdown List

Options

Once you've selected multiple values from a dropdown list and they all go into a single cell, is there any way to separate the values in the cell out into individual rows in another sheet?

Answers