Check box to excel issue

  • Profile Image
    kffdn
    Asked on November 05, 2014 at 12:33 PM

    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!

  • Profile Image
    Ben
    Answered on November 05, 2014 at 01:04 PM

    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