Amazon Interview Question

How can we Transpose a table using SQL( changing rows to column or Vice-Versa)?