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

  • Profile Image
    Jim
    Asked on August 03, 2020 at 03: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



    This is a re-post of a comment on How to Create a Grid Listing Report

  • Profile Image
    Kenneth_C
    Answered on August 03, 2020 at 06: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.png

    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.