Capture data in different columns
I would like to be able to separate the options of a multiple type column into different columns, for example, if a drop-down list with multiple selection "Texas", "New York", "North Carolina", "South Carolina" can be placed in the column ", then I would like to be able to have those three words recorded in different columns. Or even from a form, if a person wants to register the work centers where he works, he would like him to first register the first work center after being asked, Do you work in more than one work center? If the answer is yes, another box is enabled to select the name of the second and so on if there were more. I have tried to do this with formulas and also with automation flows but I have not succeeded, I would appreciate if someone could help me, thanks.