How to export submissions in excel with vertical columns?

  • Profile Image
    zehrabatool
    Asked on October 11, 2017 at 06: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 ?
  • Profile Image
    candy
    Answered on October 11, 2017 at 09: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.