Hi Tucker,
Just to be sure, you're wanting to transform (simplified example with 2 questions):
| Name | Q1 | Q2 |
|---|
| Alice | Pass | Fail |
| Bob | Fail | Fail |
| Cathy | Pass | Pass |
into:
| Name | Question | Result |
|---|
| Alice | Q1 | Pass |
| Alice | Q2 | Fail |
| Bob | Q1 | Fail |
| Bob | Q2 | Fail |
| Cathy | Q1 | Pass |
| Cathy | Q2 | Pass |
?
If that's the case, the simplest way to do this in Survey123 would be to structure the form as a repeat, with any data that is uniform for the survey (like 'Name' in the table above) being entered before the repeat and then be placed into the repeat using a calculate question.
That being said, my normal instinct would be to manipulate the first table (one row per measurement) in the database after submittal. A couple of ways to do this - the 'Transpose Fields' tool in ArcGIS Desktop can do this to create the new table out. The appropriate SQL command is UNPIVOT (see the bottom example of Using PIVOT and UNPIVOT ), which could be used to make a view of the original table.
