- zeinoneAsked 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
- gori-mathewAnswered on April 04, 2012 at 11:13 AM
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.
- zeinkallasAnswered 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?
- JotForm SupportMike_TAnswered 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.
Please feel free to contact us if you need any further assistance.
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
- JotForm SupportabajanAnswered 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.