Stack field data in same columns in Excel output?

  • 0
  • 1
  • Question
  • Updated 4 weeks 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


  • 140 Points 100 badge 2x thumb

Posted 4 weeks ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,824 Points 50k badge 2x thumb
You will need to make 10 new fields. The first field called [Stack 1] will be

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