Modify columns to rows in SQL Server

Question

How to convert columns to rows in SQL Server?

For example I have table with 31 columns as numbers from 1 to 31.

PFA screenshot for the same.

These no should range from 1 to 31 in row format.

Answer 1

You are trying to unpivot, you can use T-SQL UNPIVOT covered here: https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

Or, "An Alternative (Better?) Method to UNPIVOT (SQL Spackle)" by Dwain Camps found here: http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/