SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test (val INT);
INSERT INTO test VALUES (11),(22),(33),(44),(55),(66),(77);
WITH cte AS (
    SELECT val, ROW_NUMBER() OVER (ORDER BY val) - 1 rn
    FROM test
)
SELECT MIN(CASE WHEN rn % 2 = 0 THEN val END) column_1,
       MIN(CASE WHEN rn % 2 = 1 THEN val END) column_2
FROM cte
GROUP BY rn / 2;


column_1
column_2


11
22

33
44

55
66

77
null


WITH cte AS (
    SELECT val, ROW_NUMBER() OVER (ORDER BY val) - 1 rn
    FROM test
)
SELECT MIN(CASE WHEN rn % 3 = 0 THEN val END) column_1,
       MIN(CASE WHEN rn % 3 = 1 THEN val END) column_2,
       MIN(CASE WHEN rn % 3 = 2 THEN val END) column_3
FROM cte
GROUP BY rn / 3;


column_1
column_2
column_3


11
22
33

44
55
66

77
null
null


INSERT INTO test VALUES (88);
WITH cte AS (
    SELECT val, ROW_NUMBER() OVER (ORDER BY val) - 1 rn
    FROM test
)
SELECT MIN(CASE WHEN rn % 2 = 0 THEN val END) column_1,
       MIN(CASE WHEN rn % 2 = 1 THEN val END) column_2
FROM cte
GROUP BY rn / 2;


column_1
column_2


11
22

33
44

55
66

77
88


WITH cte AS (
    SELECT val, ROW_NUMBER() OVER (ORDER BY val) - 1 rn
    FROM test
)
SELECT MIN(CASE WHEN rn % 3 = 0 THEN val END) column_1,
       MIN(CASE WHEN rn % 3 = 1 THEN val END) column_2,
       MIN(CASE WHEN rn % 3 = 2 THEN val END) column_3
FROM cte
GROUP BY rn / 3;


column_1
column_2
column_3


11
22
33

44
55
66

77
88
null


INSERT INTO test VALUES (99);
WITH cte AS (
    SELECT val, ROW_NUMBER() OVER (ORDER BY val) - 1 rn
    FROM test
)
SELECT MIN(CASE WHEN rn % 2 = 0 THEN val END) column_1,
       MIN(CASE WHEN rn % 2 = 1 THEN val END) column_2
FROM cte
GROUP BY rn / 2;


column_1
column_2


11
22

33
44

55
66

77
88

99
null


WITH cte AS (
    SELECT val, ROW_NUMBER() OVER (ORDER BY val) - 1 rn
    FROM test
)
SELECT MIN(CASE WHEN rn % 3 = 0 THEN val END) column_1,
       MIN(CASE WHEN rn % 3 = 1 THEN val END) column_2,
       MIN(CASE WHEN rn % 3 = 2 THEN val END) column_3
FROM cte
GROUP BY rn / 3;


column_1
column_2
column_3


11
22
33

44
55
66

77
88
99