Hey,
Following from a previous query, I have a modified transpose question I'd love some help with.
My data is arranged as follows:
Subject Number | Variable 1 Rater 1 | Variable 1 Rater 2 | Variable 2 Rater 1 | Variable 2 Rater 2 | Variable 3 Rater 1 | Variable 3 Rater 2 |...Variable 103 Rater 2|
.........1
.........2
...
.........50

And I would like to transform it to

Subject Number | Variable Number | Rater 1 | Rater 2 |
..........1........................1
..........2........................1
...
..........50......................1
..........1........................2
..........2........................2
...
..........50......................2
..........1........................3
..........2........................3
...
..........50......................3
..........1........................103
..........2........................103
...
..........50......................103

In the attached worksheet, I have shown the sample input data in cells A1:G5 and the desired output in A7:D19. (The real data at present is 50 subjects and 103 variables, but the number of subjects and perhaps the number of variables will change)
All help gratefully received,
Thanks in advance,
RodSample_Transform_Question2.xlsx