Hey H Wu,
In order to tackle your problem I would start by Pivoting the different questions as it seems you have them in separated columns. Would it be much easier if you put them in a single column and then create a Table Calculation with it.
If this helps you answering your question please mark it as helpful/correct so other users may find it.
The data will need to be pivotted and structured in a certain way in order for survey data to be analysed easily.
Please see attached workbook.
Multiple Choice Surveys.twbx 22.7 KB