which function is used to convert row values into coulmn

The PIVOT statement is used for changing rows into columns in a SQL Query (Crosstab). The PIVOT Statement is generally written in this form: 
* SELECT columns
* FROM table
Aggregate Function(Measure Column)
FOR Pivot Column IN ([Pivot Column Values])
AS Alias