Is there a way to specify the order of data fields in an Excel report?

  • Profile Image
    wingsaloft
    Asked on July 08, 2013 at 10:14 AM

    Example;  My form has 6 fields of data entry.  Name, Address, City, State, Zip, Phone.  The Excel report creates a creates a column for each data field in this order:  Colum A: Name, Columb B: Address, Column C: City, Column D: State, Column E: Zip, Column F: Phone.  

    I want the column order to be different.  For instance,  Column A: Phone, Column B: City, Column C: Address, Column D: Zip, Column E: Name, Column F: State.  

  • Profile Image
    Welvin
    Answered on July 08, 2013 at 11:42 AM

    Hi,

    Unfortunately, that is not possible while generating the report. You may consider doing it manually after downloading the report. Create another excel file with your desired order then Copy and Paste data.

    Thanks