Can I convert a text column with items separated by "," or ";" to a drop down column?

Hi!

Is there a way to convert a text column with items separated by “,” or “;” to a drop down column populated by these options?

Thanks!

Hi Dan!

You can do this using the steps below :slight_smile:

  1. Ensure all text that you would like to be is separated with “,” in the Text Column.
  2. Select the down arrow next to the column name
  3. Select Change Column Type > Dropdown

This will turn each piece of text into it’s own drop down item.

Hope this helps!

Best,

Dani

Thank you @Dani!

It seems that it does make them as items to choose from in a drop down list
but doesn’t populate the column with the multiple drop down items, that were in the text field.

Here is a loom that demonstrates the issue:

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.