Discussions

Expand all | Collapse all

Stack field data in same columns in Excel output?

  • 1.  Stack field data in same columns in Excel output?

    Posted 05-23-2019 16:29
    I have a form with 10 rows of 5 fields on each row. Is it possible to build a report that will export the report to Excel without having each field on a new column in the excel file. I would like each 5 fields stacked upon each other in the same columns.

    So the current output lists each records data across a single row going out 50 columns.  I want each 5 fields on a new row stacked on top of one another.


  • 2.  RE: Stack field data in same columns in Excel output?

    Posted 05-23-2019 17:15
    You will need to make 10 new fields. The first field called [Stack 1] will be

    List("\n",
    [Field 1],
    [Field 2],
    [Field 3],
    [Field 4],
    [Field 5])

    If these are numeric fields then it gets more messy as you will ned t round them and turn them into text.