CREATE TABLE #TEMP (
Id INT
,Tname VARCHAR(100)
,MobileNumber NUMERIC(10)
,OtherMobileNumber NUMERIC(10)
)
INSERT INTO #TEMP
VALUES (1,'john',9737943110,9865986532)
,(2,'marry',NULL,8765986521)
,(3,'dally',5487986512,NULL)
SELECT
ROW_NUMBER()OVER(ORDER BY (SELECT 1)) AS ID
,Tname
,Contact
FROM #TEMP
CROSS APPLY (
VALUES (MobileNumber)
,(OtherMobileNumber)
) AS Tab(Contact)