Extract data from grid on its own row in Excel by participant.

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?

Best Answers


  • kristiakkristiak Posts: 1,266 ✭✭✭
    via Email
    Will these conversions e.g. to ACCESS allow me to get tables with several variables per line such as AE variables and so on. Lindsay, where would I start??

  • odaneodane Posts: 9
    Thank you very much Marco and Cal. I'll give your suggestions a shot!

  • MichelMichel Posts: 20
    Hi you can solve this problem....I have the same problem....
Sign In or Register to comment.