Skip to main content
Question

Stack field data in same columns in Excel output?

  • May 23, 2019
  • 0 replies
  • 46 views
Forum|alt.badge.img+9
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.
    This topic has been closed for replies.

    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.





    Terms & ConditionsAccessibility statement