Although the Pivot & Unpivot functions are really useful at times, for normalising and denormalising data, I find the syntax a pain.
I spied a simpler way of using CROSS APPLY to achieve the same results which I find easier to understand, remember, & use:
The questions and the expected response are stored on MyTable in a horizontal fashion id,q1,a1,q2,a2 etc
This query uses Cross Apply to create a subquery with the syntax similar to that used for inserting explicit values, but in reverse.
Then there is a alias and a subquery table definition like you would use in a CTE, again in reverse.