Changing the layout to rows instead of columns in Excel

  • Profile Image
    rtolmach
    Asked on December 18, 2017 at 07:47 PM
    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)
  • Profile Image
    Jan
    Answered on December 19, 2017 at 04: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.

  • Profile Image
    rtolmach
    Answered 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.

    1514478250jotform multiple sellers.JPG

    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.  

    1514478269jotform multiple books.JPG

    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

  • Profile Image
    Ardian_L
    Answered on December 28, 2017 at 01: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.

  • Profile Image
    rtolmach
    Answered on December 28, 2017 at 02:36 PM

    Hi Ardian

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

    Unauthorized Access
    Your account does not have access to this page. 
    Please switch or login your account.
     
  • Profile Image
    jonathan
    Answered on December 28, 2017 at 03: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 

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




  • Profile Image
    rtolmach
    Answered on December 28, 2017 at 04: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



  • Profile Image
    Jan
    Answered on December 28, 2017 at 07:08 PM

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

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