how to transform row data into columnar data

SQL PIVOT allow  us to  aggregate the results and rotate rows into columns  so in sort, we can say using PIVOT