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

Attached Images

	Screen Shot 2017-01-22 at 12.33.04.png (9.9 KB, 15 views)
	Screen Shot 2017-01-22 at 12.36.35.png (11.8 KB, 15 views)