I'd like a way to switch rows and columns quickly.

  • Galemas
    Asked on April 18, 2020 at 9:35 PM

    I'd like a way to switch rows and columns quickly...trying to generate sales in this COVID world and have uploaded hundreds of products, but when I download, they're going across rows instead of down a column.

  • Girish JotForm Support
    Replied on April 18, 2020 at 11:47 PM

    My understanding is that you want the Excel report form submissions layout to switch the rows and columns. 

    Unfortunately, we do not have such option in Excel reports. However, you can use the Transpose function in Excel to rotate the columns into rows or vice versa. Please check this link: https://support.office.com/en-us/article/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027 

    If you want, you can create an RSS Listing Report. Here's a guide: https://www.jotform.com/help/216-How-to-Create-an-RSS-Listing-Report 

    I hope this helps.