Changing the layout to rows instead of columns in Excel

4. 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)

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.

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

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.

Hi Ardian

I got this message when I tried to see the answer by your colleague, despite being logged in

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 

https://www.jotform.com/answers/1333290-How-to-split-products-in-payment-settings-in-google-spreadsheet

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

We are normally using LICEcap for screen capture and Monosnap for screenshots.

If you need further help, let us know. Thank you.