Transform pivot table

[morpheyz]

Hi guys!



I'm having a little problem I have to solve and I tried looking for a solution, but since I'm not really sure what to call it I couldn't find anything that would help me. So here it is:

I'm trying to do data analysis for my psychology dissertation and have a data sheet that needs to be re-sorted for use in SPSS.
My data sheet looks something like Attachment 1 (Rows I-K) with each Condition occupying its own row. However, I would like it to be split into three columns called "Subject", "Condition" and "Value" (see attachment 2, rows M-O).

So far I have simply copied and transposed each row/column, but as my data sheets are getting bigger, this is not a good option to do efficiently and mistake-free.
I have tried to meddle around with pivot tables, but these never really got the results I wanted (maybe I'm just using them wrong?)

I hope some Excel pro is able to help me.

Best

[xor]

Maybe you can use the attached.

[morpheyz]

Fantastic, that worked.
I adapted it to work with four conditions and now I've got my usable data sheet. Thanks very much!