Hi @geophile , how are you?
This is the result of the multi-select function is normal, if you want only one result in the field, you need to change the configuration of the field to single select.
There is a way to solve it.
1) Create a new column and use the formulas to copy the second option from the first to the second column, using the SEARCH() or FIND() formulas, like this:
FIND( ",", FIELD_NAME) - This formula will give you the exact position the comma is, in this example at position #8.
Then, you can use this formula: RIGHT(FIELD_NAME, 8), this formula will get all information that is on right, starting from position 8, which in this example, is only "option 2" text.
If the name of the position does not change (fixed word), you can use only one formula (RIGHT).
2) After that, you have to use the function to create a new line in the table automatically using IF() or other alternative formulas.
I hope this instruction helps you.
Have a good day! 🙂