Check box to excel issue

When I have multiple check boxes to answer 1 question, when I export to excel all the answers (the boxes that were checked) are pushed together with no delimiter all in one column.  Is there a way to have each checked box appear in it's own column or to have a delimiter placed between values in the one column?

Ex:

What options?

A.

B.

C.

D.

If they choose A,C and D, the value in the excel column 'what options' is ACD.  and I need to count the number or AS, Bs, etc in the whole worksheet.

Thanks for any advice!

Hi,

I would recommend using Grid Listing report: How to create a Grid Listing report

It should be showing the values differently for you.

Could you please also tell us which jotform is this happening on please since I see that you have over 60 of them?

Also can you please tell us a few more details, such as should they only choose one option or several of them and if you use these values somewhere in the jotform?

Best Regards,
Ben