- cheryl6922Asked on March 20, 2015 at 01:25 PM
Beautiful upload to my adobe form.... however I need separate columns for each choice in Excel, so I can sort the choices in Excel.. is there a formula - calculation that will separate the br into columns in Excel? I was having trouble with this issue in Cognito, which is why I'm trying Jot.... LOVED THE UPLOAD FEATURE.....
- CharlieAnswered on March 20, 2015 at 03:15 PM
Thank you for your appreciation to our product.
Regarding the question, I would assume you are referring to the Google Spreadsheet integration, is that right? If you are looking on to separating the choices in the input fields to new columns, unfortunately if cannot be done automatically through our end.
But it is possible using some formulas in Google Spreadsheet.
I believe you are looking on to using the SPLIT function, you can learn more about it here: SPLIT on Google Spreadsheet
Another function that you might be interested is using the IMPORTRANGE, this will allow you to merge separate sheets to one. You can check it here: https://support.google.com/docs/answer/3093340?hl=en.
I hope this helps.