Convert Columns to Rows using UNPIVOT in SQL Server query

This way:

--CREATE TABLE
CREATE TABLE [dbo].[tblPivote](
	[Column 1] [int] NULL,
	[Column 2] [int] NULL,
	[Column 3] [int] NULL
) ON [PRIMARY]

-- INSERT 
INSERT INTO [Sample].[dbo].[tblPivote]
           ([Column 1]
           ,[Column 2]
           ,[Column 3])
     VALUES
           (7
           ,5
           ,8)

-- UNPIVOT
SELECT [Column A] ,[Column B]
FROM 
   (SELECT [Column 1], [Column 2], [Column 3]
   FROM tblPivote) p
UNPIVOT
   ([Column B] FOR [Column A] IN 
      ([Column 1], [Column 2], [Column 3])
)AS unpvt;
GO

Image:

Thank You.