What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
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.
Sorry, I have moved your question into a separate thread since this question does not relate to your previous one. Please find my response below.
You can actually separate each value on a cell into each column.
Check this thread to find out how it is done. http://www.jotform.com/answers/214003-Separating-purchased-products-in-Excel-export-of-submission-data#214037
Let us know if you have further questions or if you need further assistance.
Thank you! I will try that. :)
I think it's over my head. LOL
I found another set of directions that were easier for me to understand but I don't have regular excel. I have excel starter and I've tried google sheets and in neither one can I find text to columns.
I don't think this is going to work for me but thanks anyway.
Thank you for updating us and we aplogize for the delayed response.
Are we good to assume that you had found the resolution?
Please inform us if you need our assistance further.
The problem is, neither excel that I have access to will work with this method. There's no 'text to columns' option I can find.
However, I am VERY happy to say I found the easiest solution of all right on the submissions page! For my particular form it works. I just have to put the name of the state in the search bar at the bottom and it tells me how many submissions were made for that state. The counting is done for me and no sorting!
Sorry it didn't work on the version of MS Excel you have installed on your computer and we are happy that you find another work around that suits your needs. With that being said, are we okay to assume that you're good to go?
Let us know if there's anything else we can do for you.