How to create a Dropdown from a CSV String in a column?

[lpfrnk]

Hello,

Trying to figure out how to convert a CSV string to a dropdown such that one of the values can be selected?

Example:

Bob,Joe,Tom is in row10, column1

When row10 column1 one is selected, I would like to display a dropdown of the names such that one may be selected. I am able to leverage split and index 1,2,3 but no luck with a dropdown.

Thanks.