Excel 2007 : Problem Paste Special Transpose

Hi
I have a file which is exam results. The file has the following layout:
Test Name, Student Name, Q1,Q2,.... (question nr)
Test Name, Student Name, a,b,.... (answer chosen)
Test Name, Student Name, 1,0,.... (points scored)

I need to get the layout as follows because it has to be imported into a table:
Test Name, Student Name, Q1,a,1 (question nr, answer chosen, points scored)
Test Name, Student Name, Q2,a,1 (question nr, answer chosen, points scored)

I don't know any other way to do this than with paste special transpose, but I can't do this manually since there is 2,500 entries, can someone please advise me on this.

I ataached examples.

Help will be apreciated!