JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Downloading submissions where a question has multiple tickboxesAsked by MichaelBrightman on July 30, 2014 at 11:14 AM
On our survey a number of questions tell the person filling it out to tick all boxes that apply. When the information downloads the answer for that question is all on one line in excel and it cannot be separated out into separate columns easily because there is no delimiter or comma as such. Is there a way to download answers to questions where multiple boxes have been ticked that solves this problem?
Thanks in anticipation
Submissions survey problem excel separate columns
Unfortunately, they're configured to display in that manner. However, you can try the following workaround on how to place them into separate columns using excel formula.
Actually, you can add delimiters on each options per line since each option are brought down into new lines. You can use the following formula. This will add ^ symbol as delimiter on each option per line. You can drag down to automatically apply it on the other cells.
After that, highlight the column containing the formula, then go to Data --> Text to Columns. When the Wizard comes up, select Delimited on the first screen and Other on the next screen. In the blank space next to Other, insert ^. Click Finish, and your products should be listed in separate columns.
If you need further assistance, let us know here.
Thanks for this,
Your question is moved to a separate thread and shall be answered there shortly.