Simple way to transpose columns and rows in SQL

Question

How can I quickly switch rows and columns in SQL? Exists a straightforward command to transpose?

Turn this result:

        Paul  | John  | Tim  |  Eric
Red     1       5       1       3
Green   8       4       3       5
Blue    2       2       9       1

Into this:

        Red  | Green | Blue
Paul    1       8       2
John    5       4       2
Tim     1       3       9
Eric    3       5       1

PIVOT seems too complex for this scenario.