SQL Server PIVOT operation which rotates a table-valued expression. It turns the unique values in one column into multiple columns in the output and performs aggregations by SUM (), COUNT (), AVG (), ...