How to export submissions in excel with vertical columns?

  • zehrabatool
    Asked on October 11, 2017 at 6:04 AM
    Second thing I want to ask you that I want values from jotform should be fall on excel report in vertical columns NOT in horizontal column.
    How can I obtained it ?
  • candy
    Replied on October 11, 2017 at 9:04 AM

    Unfortunately, it is not possible to decide how the exported Excel sheet will be generated vertically or horizontally. When the information is exported to Excel, each submission in placed in a row, with each column representing each field in your form.

    If you would like to determine what fields are included or excluded, you can create an Excel Report.

    Besides, you are able to use excel tools to switch the rows and columns as you can see in the following guide: https://www.timeatlas.com/switch-excel-columns-rows/ 

    I hope this helps.