Create a Binary-Multi variable from single Excel column
J
Jan Jesenovec
See example:
Often, when users import Excel files, multi-choice answers are saved in the same column, separated by a ";"
Q/Displayr read this as a Text or Single choice variable.
There is no automated way to change this to a Binary - Multi.
The workaround is to code the responses or use a List of items. See the link above for details.
Ideally, this type of question would be recognized during import, or we would have a script to do this in one go; and update the variable if the data set is updated.