Separating data grouped in one cell in the Excel export of submission data

  • Profile Image
    zeinone
    Asked on April 04, 2012 at 10:02 AM

    Hello to all

    In my form I have several questions that allow respondent to select more than one option at the same time (different plausible answers). However, in the Excel I obtain all selected option in the same cells separated by a strange symbol like this: ?.

    They are not separated by a space. Because if they are, I can later separate them using the Excel option of: text to data tools, but it is not the case.

    How can I obtain different columns for each option answered in my Excel even if they belong to the question?

     

    Many thanks for your helps

  • Profile Image
    gori-mathew
    Answered on April 04, 2012 at 11:13 AM

    Hi,

    I don't know if i get your question right, you need possible ways or re-arrangind excel data? If so You  can collate all submissions made through your form using the Export to Excel feature and format this data too. Just go to your form's submissions page and look for this button:

     

    Each field will be sorted and given its own column.

    Furthermore, using Excel's built in sort and filter functions, you can group entries of the same kind together,  for example same state or same color preference. You can also arrange in alphabetically or numerically in ascenting or descending order.

    Hope this information is helpful to assist you in re-arranging excel data. Please lets know if you need further assistance.

     

  • Profile Image
    zeinkallas
    Answered on April 04, 2012 at 03:24 PM

    Thank you for you answer. but that's not what I wanted. I'll try to better explain my question by an example.

     

    Let suppose i have this question:

     

    Q1. which option/s is/are your prefered .....?

            ESAB          CREDA         UPC        IRTA

    So respondents can answer more than one option simultaneously. 

    in the obtained excel, the values are puted together in the same cell without any separation

    ESABCREDAUPC (if a respondent answered ESAB, CREDA, UPC)

    can I obtain answers in diffrent cells (one cells for each option?

     

     

  • Profile Image
    Mike_T
    Answered on April 04, 2012 at 07:50 PM

    Unfortunately, this is not possible to obtain answers in different cells for one Check Box field. You will have to use several Check Boxes for this.

    It is also possible to put these separate Check Boxes on the same line.

    How to Position Form Fields on the Same Line

    Please feel free to contact us if you need any further assistance.

  • Profile Image
    Answered on April 05, 2012 at 03:30 AM

    Dear, Mike

     

    Thank you for your answer

    I have already use several Check Boxes for this (as you shown me in your attached image), but I still obtaining all values in one cell (if respondent check more than one option). It is normal to obtain this?

     

    many thanks again

  • Profile Image
    abajan
    Answered on April 05, 2012 at 04:32 AM

    If you are getting all the values in one cell, there has been a misunderstanding. What my colleague meant was that you should use multiple check box fields, each containing a single check box. I believe what you have done is the opposite: a single check box field containing multiple check boxes.