Can a report be exported in excel to run down the cells & not across columns.

  • Jim
    Asked on August 3, 2020 at 3:27 PM

    Hi,

    Can a report be exported in excel with the form questions to run down the cells & not across the columns.

    e.g headers as follows;

    Store_Name,Review_date,Review_Question,Review_Question_Result

    Test Store A,09/11/2020,Floor Clean,Yes

    Test Store A,09/11/2020,Bench Clean,Yes

    Test Store A,09/11/2020,Door Clean,No

    Test Store B,09/11/2020,Floor Clean,Yes

    Test Store B,09/11/2020,Bench Clean,Yes

    Test Store B,09/11/2020,Door Clean,Yes

    Thanks Jim

  • Kenneth JotForm Support
    Replied on August 3, 2020 at 6:34 PM

    Thank you for reaching support,

    To clarify, you wish that the excel report exported has a horizontal orientation just as it shown in the Grid Listing report?

    1596493871t1 Screenshot 10

    If so, then, unfortunately, our excel export does not have that feature, however, you may use the Transpose function in Excel to rotate the columns into rows or vice versa. Here is the Guide: https://support.microsoft.com/en-us/office/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027?ui=en-us&rs=en-us&ad=us

    I hope that helps.

    Best.