how to transform columns data into rows data

SQL Server UNPIVOT allow us to transform columns of a table-valued expression into column values that is rotating columns into rows.

It performs a reverse operation of SQL Server PIVOT.

SYNTAX
SELECT …
FROM …
UNPIVOT (
FOR IN ( ) )

[ … ]