When exporting my data into Excel, it presents the fields horizontally.

  • Profile Image
    NCUCapex
    Asked on February 25, 2017 at 12:02 PM

    When exporting my data into Excel, it presents the fields horizontally. Is there a way to present the information in Excel so that it presents the fields vertically? Example:

    Field 1 Field 2 Field 3

    Want it like this:

    Field 1

    Field 2

    Field 3

    Thanks!



    This is a re-post of a comment on How to Create an Excel Report?

  • Profile Image
    Jim_R
    Answered on February 25, 2017 at 02:50 PM

    I'm afraid the Submissions Data will always be exported in that manner. Form Fields act as the sheet column headers and it's the usual, most natural way of displaying data.

    What you can do is transpose the rows and columns in Excel if you prefer to view it the other way around.

    Related article: Transpose-rotate-data-from-rows-to-columns-or-vice-versa