The Dropdown Settings contains the following sections:
Separator
This determines how the dropdown values for each individual item is separated
In the example image shown above, the first item will have dropdown values of “A” and “B” and the second item will have a value of “C”. If the wrong or different Separator option is chosen, for example “Comma” instead of “Semicolon”, then the first item will have a value of “A;B”.
By default, the Separator dropdown offers a list of default separators you can use. In case the separator you are looking for is not available in the list of options, you can write your custom separator directly into the input box.
For example, if the individual row data is separated by an ampersand, you can input an ampersand symbol directly in the Separator input box as shown in the image below
