Forum Discussion

BrianDunk's avatar
BrianDunk
Qrew Cadet
6 years ago

Stack field data in same columns in Excel output?

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.
  • 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.