How to separate values from one column into two columns in SQL Server
Here's an example which does what you want and will get you started with using PIVOT. Sorry it is a bit rushed, but hopefully it will get you started and show you how it can be done fairly easily.

There will be limitations and I would fully advise researching and playing with the pivot functions because they are really powerful.

-- Some sample data to work with
DECLARE @SampleData AS TABLE (
    NAME VARCHAR(20)
    ,contactnumber BIGINT
    )

INSERT INTO @SampleData
VALUES (
    'Deepika'
    ,75865558
    )
    ,(
    'Deepika'
    ,5181568
    )
    ,(
    'Deepika'
    ,56954121
    )
    ,(
    'Rnveer'
    ,4561896
    )
    ,(
    'Rnveer'
    ,48640655
    )
    ,(
    'vaibhav'
    ,48640655
    );

--The pivot
WITH PivotData
AS (
    SELECT NAME --The row group
        ,'Contact ' + CAST(ROW_NUMBER() OVER (
                PARTITION BY NAME ORDER BY contactnumber ASC
                ) AS VARCHAR(1)) AS TheRow --The value that will form columns
        ,contactnumber
    FROM @SampleData
    )
SELECT *
FROM PivotData
PIVOT(AVG(contactnumber) FOR TheRow IN (
            [Contact 1]
            ,[Contact 2]
            ,[Contact 3]
            ,[Contact 4]
            )) AS ThePivot1