Stackoverflow - how to split single integer value columns into n column?, Sql Server

Language: Layout:

SELECT TOP 100 IDENTITY(int,1,1) AS col1
        INTO table_name
        FROM sys.objects s1       
        CROSS JOIN sys.objects s2

DELETE
    FROM table_name
    WHERE col1 IN
    (
        SELECT TOP 67 col1
        FROM table_name
        ORDER BY NEWID()
    )
    
-- table_name now contains 33 random numbers between 1 and 100

;With Cols as
    (
        SELECT  col1, 
                ROW_NUMBER() OVER(ORDER BY col1) % 5 ColNumber
        FROM table_name
    ), RowsAndCols as
    (
        SELECT col1, ColNumber, ROW_NUMBER() OVER(PARTITION BY ColNumber ORDER BY col1) As RowNumber
        FROM Cols
    )

SELECT c1.col1, c2.col1 As col2, c3.col1 As col3, c4.col1 As col4, c5.col1 As col5
    FROM RowsAndCols c1
    LEFT JOIN RowsAndCols c2 ON c1.RowNumber = c2.RowNumber AND c2.ColNumber = 2
    LEFT JOIN RowsAndCols c3 ON c1.RowNumber = c3.RowNumber AND c3.ColNumber = 3
    LEFT JOIN RowsAndCols c4 ON c1.RowNumber = c4.RowNumber AND c4.ColNumber = 4
    LEFT JOIN RowsAndCols c5 ON c1.RowNumber = c5.RowNumber AND c5.ColNumber = 0
    WHERE c1.ColNumber = 1

View schema
Execution time: 0,06 sec, rows selected: 7, rows affected: 67, absolute service time: 0,23 sec

Stackoverflow - how to split single integer value columns into n colum...