[SOLVED] Data manipulation

Is it possible to convert a table such as this:

HTML Code: 

to this:

HTML Code: 

Where all question 1 fields are put into a row, 2 in another row, etc (this may be more than 2 sets of questions), grouped by the name field.

I have had a look at Pivot tables but they dont seem to do what Im after.

Many thanks in advance.