Hi,
Try the below Code...
DECLARE @PhoneDtls TABLE (Empno INT, PhoneType VARCHAR(20), Number VARCHAR(20))
INSERT INTO @PhoneDtls(EmpNo,PhoneType,Number)
SELECT 100,'Mobile','1234'
UNION ALL SELECT 100,'Telephone','3456'
UNION ALL SELECT 101,'Mobile','5678'
UNION ALL SELECT 102,'Telephone','7890'
UNION ALL SELECT 103,'Mobile','3412'
SELECT EmpNo,PhoneType,Number FROM @PhoneDtls
SELECT T.EmpNo,
ISNULL((SELECT Number FROM @PhoneDtls WHERE PhoneType ='Mobile' AND EmpNo=T.EmpNo),'-') 'Mobile',
ISNULL((SELECT Number FROM @PhoneDtls WHERE PhoneType ='Telephone' AND EmpNo=T.EmpNo),'-') 'Number'
FROM (SELECT DISTINCT EmpNo FROM @PhoneDtls) T
Regards,
GVPrabu