Sorting randomized question/answers within rows?

Hi,

Can someone suggest a workaround for the following?

Four people are given four questions in a random order. Is there some way of sorting the questions and associated answers within rows, such that all of the same questions appear in the same row?

Example attached.

Thanks in advance!

Originally Posted by 6StringJazzer

See third set of answers using formulas.

Excellent - that you very much!!