DROP TABLE #Employee

CREATE TABLE #Employee (ID INT, Name VARCHAR(10), Age INT, Country CHAR(2), Manager VARCHAR(10), Status CHAR(1));

INSERT INTO #Employee (ID, Name, Age, Country, Manager, Status)

SELECT 1,'Ravi',29,'IN','Anil','A' UNION ALL

SELECT 2,'Balaji',30,'IN','Siju','A' UNION ALL

SELECT 3,'Sanjeev',31,'IN','Venkat','A'

SELECT ID, Name, Age, NewColumn

FROM ( -- derived table is unnecessary if Seq is acceptable in output

SELECT ID, Name, Age, NewColumn = CAST(Country AS VARCHAR(10)), 1 AS Seq

FROM #Employee

UNION ALL

SELECT ID, Name, Age, NewColumn = CAST(Manager AS VARCHAR(10)), 2 AS Seq

FROM #Employee

UNION ALL

SELECT ID, Name, Age, NewColumn = CAST(Status AS VARCHAR(10)), 3 AS Seq

FROM #Employee

) d

ORDER BY ID, Seq