Importing and exporting multi-select columns

Options

Hi,

I've imported data from MS Forms via Excel. There are several columns which contain data from multi-select answers. What is the best way to import these?

I've done some of it manually, but I'm finding it difficult to verify with the original as when I export to Excel all the multi-select entries are concatenated.

Thanks, Nichola

Answers