Splinting multiple choice responses in excel when excel it is connected to the server

How can I splint the multiple choice responses in excel when it is connected to the server?

Hello @Dushime,

I guess if you use ODK briefcase to export your data, you have option to split your select_multiple responses.

Alternatively, post a full question with your environment/setup for a full understanding of the issue you are facing

Best,
Jules R

I know well ODK briefcase, but my case is not exporting data in excel, the issue is when your excel is linked to the server by using API and then I am asking how to splint the multiple responses in that excel for dynamic dashboard purpose.