CREATE DATABASE test;
use test;
CREATE TABLE F0915(
YEAR VARCHAR(10),
MONTH VARCHAR(10),
AMOUNT DECIMAL(18,1)
);
INSERT INTO F0915 VALUES
('2020','1',9.1),
('2020','2',9.2),
('2020','3',9.3),
('2020','4',9.4),
('2021','1',8.1),
('2021','2',8.2),
('2021','3',8.3),
('2021','4',8.4);
SELECT * FROM F0915;
SELECT
YEAR,
MAX(CASE WHEN MONTH = 1 THEN AMOUNT ELSE NULL END) M1,
MAX(CASE WHEN MONTH = 2 THEN AMOUNT ELSE NULL END) M2,
MAX(CASE WHEN MONTH = 3 THEN AMOUNT ELSE NULL END) M3,
MAX(CASE WHEN MONTH = 4 THEN AMOUNT ELSE NULL END) M4
FROM F0915
GROUP BY YEAR;