Completely agree with the solutions already given. If you still have not completed the task manually, but are waiting for a ready-made solution, then I will offer my own version.
Turn on macro recording.
Specify the "hot key" you will use to launch (for example, Ctrl-g)
Start pressing the buttons in a sequence that should lead you to copy and transpose one group of answers in the right place:
Ctrl-Home,
Right Arrow,
Ctrl-Down Arrow,
Ctrl-Shift-Down Arrow (the first group of questions is highlighted),
Ctrl-C (copy to clipboard),
Ctrl-End,
Ctrl-Left Arrow,
Ctrl-Alt-V (specify "transposed"),
Enter,
and again Ctrl-Home,
Right Arrow,
Ctrl-Down Arrow,
Ctrl-Shift-Down Arrow
and Delete (the first group of questions is deleted).
Stop macro recording.
You may need to change one or two lines of code to select first empty cell at the end of table. Somethig like as
ActiveCell.SpecialCells(xlLastCell).Select
Range("A" & (Selection.Row + 1)).Select
I hope that the nickname you have chosen indicates that this will not be a problem for you.
Now press Ctrl-g until you reach the end of the list. Column B is now cleared and all the answers from it are collected in the table at the bottom of the page.