How to pull the information into an excel doc with each row as a different column

  • Events Membership
    Asked on February 23, 2023 at 3:11 AM

    how do i pull the information into an excel doc with each row as a different column?

    Page URL: https://www.jotform.com/help/282-how-to-set-up-the-configurable-list-widget/
  • Luna JotForm Support
    Replied on February 23, 2023 at 3:45 AM

    Hi Events Membership,

    Thanks for reaching out to Jotform Support. It's not possible to rotate (transpose) data from rows to columns in our system. But after you download your submissions as an Excel file, you can do it manually in Excel. Check out the steps below to see how to download your submissions in Excel format:

    1. On your My Forms page, choose your form and click the Submissions button.

    1637046345 6193584947e21 Screen Shot 202 Screenshot 10

    2. If you want to download all of the submissions, click on Download All on the right side of the page and then select Download as Excel.

    MimJ5Yn84Giw3 8Ae vhBJMZv8XcYB5Jnhb JLy1 Screenshot 21

    3. Download the Excel file with your submission data in it and use a program like Microsoft Office to open it. OYvEARFB0OmSb8e CFo5xFmCFc3D3XkV4AhMGzzP Screenshot 32

    We also have a guide about How to Download Form Submissions as Excel/CSV/PDF that you can check out.

    After you download the Excel file with your submission data, you can check out the user guide about How to Transpose (rotate) Data from Rows to Columns or Vice Versa that you can check out.

    Give it a try and let us know if you need any help.