FIRST

i very much thought we had agreed that the data would be returned as one table so that users would not have to join different tables on their own.

That was my understanding as well. I'm perplexed about what problem this bug actually expresses.

added a new "pivot" option when downloading data.
the dataset can now be returned with questions and metadata for each question as a separate column rather than a row.

csv sample for a single student taking an exam with three questions.

This is an actual file downloaded from my local system.
It is a single-question exam taken by 11 students. No response data was captured, only scores.
Notice that the vocab/value is in a single column - this is different from what we had decided on at the last meeting, but I believe it is the last outstanding item to address for this data return format.

I've split the vocab/value into two columns (nbii | Biopolymers) as agreed on last week.

without the "transponse" box checked

with the "transpose" box checked

addressed the comments from today's meeting:
-html is stripped out for both return formats
-studentIds are changed to sequential numbers
-studentId column labels are relabeled "recordNum"
-duplicate true/false values for the metadata matrix are omitted

Original Bugzilla ID was 3876