Rearrange two sets of ten columns into two columns

Question

I have a table with a name column and ten question columns with the name and answers under the relevant columns.

How do I format the ten question columns into one column with each question on a separate row and a new column for the answer to that particular question?

Answer 1

It is called a 'reverse pivot'. Construct a PivotTable with multiple consolidation ranges (Alt+D, P if necessary) and double click on the Grand Total. The correct answers would have to be added in some other way however, since not given in your question.