What does the SQL PIVOT operation do?

A Transposes the entire table so rows become columns and columns become rows B Sorts the result set along two dimensions simultaneously C Rotates columns into rows, normalizing wide tables into a long format D Rotates rows into columns, transforming distinct values from one column into multiple columns with aggregated values