-
rtolmachAsked on December 18, 2017 at 7:47 PM4. If we collect the info this way, we will have a very wide spreadsheet with all the info for a person in one row like this simplified version with two books:
George Washington George@aol.com Biology book $45.00 good-condition Chemistry book $32 new-condition
Is there a way we can get it to automatically display for us in multiple rows like this:
George Washington George@aol.com Biology book $45.00 good-condition
George Washington George@aol.com Math book $32.00 new-condition
Or even this would help:
George Washington George@aol.com Biology book $45.00 good-condition
Math book $32.00 new-condition
Or do we need to break the long line into separate lines in Excel? (We will need separate lines to import books into our website) -
JanReplied on December 19, 2017 at 4:21 AM
My understanding is that you want the Excel form submissions layout to be in rows instead of columns.
Unfortunately, we do not have such option in Excel reports. However, you can use the Transpose function in Excel to rotate the columns into rows. Please check this link: https://support.office.com/en-us/article/Transpose-rotate-data-from-rows-to-columns-or-vice-versa-3419f2e3-beab-4318-aae5-d0f862209744.
If you want, you can create an RSS Listing Report. Here's a guide: https://www.jotform.com/help/216-How-to-Create-an-RSS-Listing-Report.
Hope that helps. Thank you.
-
rtolmachReplied on December 28, 2017 at 11:31 AM
I may not have been clear. It is not a matter of wanting the CSV / Excel form submissions layout to be in rows instead of columns.
Please see these two images:
If I have a form for each book, then someone listing 4 books would have to complete 4 forms, and I would get the data in a CSV or Excel like this, which is easy to work with.
However, the downside of that is that the seller has to re-enter his own info (Seller name, etc.) for each separate form. We use an email validator, so they also have to validate the email again for each separate form. That is not a good user experience.
If I have a single form that allows them to enter multiple books, then someone listing 4 books would just have to complete 1 form. However, I would get the data in a CSV or Excel like this (I did not even show the full width. You can imagine what it looks like if they submit 10 books.
Ultimately, we need the data in the form of the first chart I show. I could do the following, but it would be burdensome:
-- I could manually enter a blank row in the chart for each book after the first one,
-- then drag book 2 data into the first of those blank rows
-- then copy the seller info from book 1 into the correct cells of the row for book 2
-- then repeat for each additional book.
Ugh!
Is there a better solution, which would let the visitor submit multiple books in one form, but get me the data in the form of the first chart shown above?
Thanks!A
-
Ardian_LReplied on December 28, 2017 at 1:03 PM
Unfortunately we can not separate the submission into different rows.
Please check this answer by my colleague, he has provided a workaround which is not similar with your request. But almost what you are looking for, I would suggest you to give it a try.
Let us know if you have any other question.
-
rtolmachReplied on December 28, 2017 at 2:36 PM
-
jonathanReplied on December 28, 2017 at 3:26 PM
We apologize for the inconvenience caused. The discussion thread was set to private mode by the original user the reason you were not able to view/read it.
Anyway I created a separate thread for the resolution provided by our colleague from that thread. You can review the solution here
-
rtolmachReplied on December 28, 2017 at 4:47 PM
Thanks. I used the text-to-columns trick all the time, but the starting point in our scenario is very different from that shown in this prior article.
I have another way I can deal with our situation in Google docs.
BTW, what software do you use for your screencaster grabs?
best
Robert
-
JanReplied on December 28, 2017 at 7:08 PM