Millisecond Forums

Hi Dave, hi everyone,

I just took a look at our merged dataset and what confuses me is that it is not ordered according to subject number. Instead we have the subject number in one column repeatedly and the variables of all tests in the rows next to that, however their values in the rows below. I give you a hypothetical example below:

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

What I would like to have is the usual organisation in: one row per subjects. I know, we could restructure the data set with SPSS, however at this point, that does not seem like an easy option. Can I change that in Inquisit, so it looks like this:

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

Thanks in Advance
M.