Hey,
I am trying to transpose some data for a repeated measures study we are doing.
I have a series of variables that are measured on one occasion each by two different raters.
This data is currently arranged in columns as follows:
"Subject No" , "Rater" , "Variable1" , "Variable2" , ... i.e. total columns = 2 + number of variables
Subject Rater Var1 Var2 Var3
Number
1 1 12 16 19
2 1 20 17 16
3 1 10 10 20
1 2 10 12 14
2 2 10 16 18
3 2 15 18 17
I would like to transpose this so that I end up with the data organised into 4 columns (only):
"Subject Number" , "Rater" , "Variable No" , "Measure"
Subject Rater VarNo Measure
Number
1 1 1 12
1 2 1 10
2 1 1 20
2 2 1 10
3 1 1 10
3 2 1 15
1 1 2 16
1 2 2 12
2 1 2 17
2 2 2 16
3 1 2 10
3 2 2 18
1 1 3 19
1 2 3 14
2 1 3 16
2 2 3 18
3 1 3 20
3 2 3 17
For a few variables & subjects this is trivial copy & paste, but I have 103 variables with 100 subjects and 2 raters, so I will make a mistake for sure doing this manually (and go mad into the bargain).
I have attached a sample sheet showing the some dummy input data in the range A1:E7 and the desired output in H1:K19 (3 subjects, 2 raters, 3 variables) as I doubt the copied and pasted data above is very clear.
Thanks in advance for any help,
Rod
Bookmarks