Stack field data in same columns in Excel output?

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
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.
Photo of Brian

Brian

  • 140 Points 100 badge 2x thumb

Posted 1 month ago

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