SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1
    ([order_] int, [date_] date, [sum_] int,
     [order_1] int, [date_1] date, [sum_1] int,
     [order_2] int, [date_2] date, [sum_2] int,
     [order_3] int, [date_3] date, [sum_3] int,
     [order_4] int, [date_4] date, [sum_4] int,
     [order_5] int, [date_5] date, [sum_5] int,
     [order_6] int, [date_6] date, [sum_6] int,
     [order_7] int, [date_7] date, [sum_7] int,
     [order_8] int, [date_8] date, [sum_8] int,
     [order_9] int, [date_9] date, [sum_9] int
    );

INSERT INTO table1
    ([order_], [date_], [sum_],
     [order_1], [date_1], [sum_1],
     [order_2], [date_2], [sum_2],
     [order_3], [date_3], [sum_3],
     [order_4], [date_4], [sum_4],
     [order_5], [date_5], [sum_5],
     [order_6], [date_6], [sum_6],
     [order_7], [date_7], [sum_7],
     [order_8], [date_8], [sum_8],
     [order_9], [date_9], [sum_9]
    )
VALUES
    (1, '2020-01-01', 1000,
     2, '2020-01-02', 2000,
     3, '2020-01-03', 3000,
     4, '2020-01-04', 4000,
     5, '2020-01-05', 5000,
     6, '2020-01-06', 6000,
     7, '2020-01-07', 7000,
     8, '2020-01-08', 8000,
     9, '2020-01-09', 9000,
     10, '2020-01-10', 10000
    );
    
SELECT * FROM table1;

order_	date_	sum_	order_1	date_1	sum_1	order_2	date_2	sum_2	order_3	date_3	sum_3	order_4	date_4	sum_4	order_5	date_5	sum_5	order_6	date_6	sum_6	order_7	date_7	sum_7	order_8	date_8	sum_8	order_9	date_9	sum_9
1	2020-01-01	1000	2	2020-01-02	2000	3	2020-01-03	3000	4	2020-01-04	4000	5	2020-01-05	5000	6	2020-01-06	6000	7	2020-01-07	7000	8	2020-01-08	8000	9	2020-01-09	9000	10	2020-01-10	10000

order	date	sum	balance
1	2020-01-01	1000	1000
2	2020-01-02	2000	3000
3	2020-01-03	3000	6000
4	2020-01-04	4000	10000
5	2020-01-05	5000	15000
6	2020-01-06	6000	21000
7	2020-01-07	7000	28000
8	2020-01-08	8000	36000
9	2020-01-09	9000	45000
10	2020-01-10	10000	55000