Hope this helps
CREATE TABLE Test
(
Id INT IDENTITY, SenderName VARCHAR(30),SenderMobile INT,
SendToName VARCHAR(30),SendToMobile INT
)
INSERT Test VALUES
('PersonA',53433423,'PersonB',34394388),
('PersonC',43434324,'PersonD',93483988)
SELECT * FROM Test
Id SenderName SenderMobile SendToName SendToMobile
1 PersonA 53433423 PersonB 34394388
2 PersonC 43434324 PersonD 93483988
SELECT IDENTITY(INT,1,1) AS Id, A.[Sender Name],A.[Sender Mobile] INTO #NewTab
FROM
(
SELECT T.SenderName [Sender Name],T.SenderMobile [Sender Mobile] FROM Test T
UNION ALL
SELECT T.SendToName [Sender Name],T.SendToMobile [Sender Mobile] FROM Test T
)A
SELECT * FROM #NewTab
Id Sender Name Sender Mobile
1 PersonA 53433423
2 PersonC 43434324
3 PersonB 34394388
4 PersonD 93483988