<data> records in *long* format. You need to sort and restructure long format files to prepare them for analysis. This is not hard once you have done it a few times. See e.g www.tqmp.org/RegularArticles/vol02-1/p020/p020.pdf .

You can make use of <summarydata>, which allows you to capture a single line of summary metrics per subject.

Hi Dave,

thanks!
Could you please explain how to use <summarydata> to capture a single line for each subject? There is no attribute, such as /rows in which I could put the subject-id. 

Best 
M.

You specify a <summarydata> element as detailed in the documentation: https://www.millisecond.com/support/docs/v5/html/language/elements/summarydata.htm

The /columns attribute is where you specify the variables you want it to capture. For the subject id that's

/ columns = [script.subjectid ...]

Hi Dave,

I'm mongrel's colleague and we're working on the same project. We have already specified all the variables and the data that is written looks fine - that's not the problem. The problem is the data's format, as described in the initial post under this topic. Rather than having separate columns for each attribute, we'd like to have one column per participant:

participant   Test1   Test2   Test3
1                      5          7         1
2                      2          2         2
3                      6          6         6
4                      4          4         7

This is what it looks like in any SPSS spreadsheet which is why we would much prefer this format for our output if possible. 

Thanks,

Sandra

I'm attaching two pictures, hoping to better explain what the issue is. On the left is the Inquisit data output. As you can see, we get the data from subject (participant) 1 in about 120 seperate columns (you can only see 9 on the screenshot). What we want is what's shown on the right: get one(!) row per subject with all the subject's data in it.