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

how to split single integer value columns into n column?

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 8, rows affected: 3, absolute service time: 0,17 sec

edit mode | history

  
col1
col2
col3
col4
col5

1
1
2
3
4
5

2
6
7
8
9
10

3
11
14
15
16
18

4
19
20
NULL
NULL
NULL


  
col1
col2
col3
col4
col5

1
1
2
3
4
5

2
6
7
8
9
10

3
11
14
15
16
18

4
19
20
NULL
NULL
NULL

λ

                                      .NET NoSQL database for rapid development