-
JimAsked 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 Enterprise SupportReplied 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?
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.