divide one column of sql table

1)create table emp(FirstName)
2)insert the values in that suppose i have 7 values
Sandeep
Prasad
Sharad
Sachin
Ravi
Ashish
Mangesh

3);WITH T
     AS (SELECT firstname,
                ( ROW_NUMBER() OVER (ORDER BY (SELECT 0)) - 1 ) / 4 AS Row,
                ( ROW_NUMBER() OVER (ORDER BY (SELECT 0)) - 1 ) % 4 AS Col
         FROM   tempemp)
SELECT [0] AS Column1,
       [1] AS Column2,
       [2] AS Column3,
       [3] AS Column4
FROM   T PIVOT (MAX(firstname) FOR Col IN ([0], [1], [2], [3])) P 
ORDER BY Row

Column1  Column2  Column3   Column4
Sandeep	 Prasad	  Sharad    Sachin
Ravi	 Ashish	  Mangesh   NULL