Why does OpenClinica extract data entered into a grid (repeating) field on one row in Excel? Please see the attached example Excel files. "Extract 2-3-16 old" is how OpenClinica currently exports these data "Extract 2-3-16 new" is in a more usable form for my needs, where each entry for each participant is on its own row of the Excel file.
Basically, I would like for the data to export how the grid appears on the screen for the data entry person.
Are there any alternatives or suggestions?