Display data horizontally using UNPIVOT in SQL Server

Hi abc,

Refer below sample query.

SQL

CREATE TABLE #TestCustomers(Id VARCHAR(20), Name VARCHAR(20), [Address] VARCHAR(20))
INSERT INTO #TestCustomers VALUES(1,'abc','Pune')

SELECT DISTINCT [Column A] ,[Column B]
FROM
   (SELECT [Id],[Name],[Address]
   FROM #TestCustomers) p
UNPIVOT
   ([Column B] FOR [Column A] IN
      ([Id],[Name],[Address])
)AS unpvt;
DROP TABLE #TestCustomers

Output