Question d’entretien chez Amazon

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