SQL Server 2017

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

CREATE TABLE A (

XYEAR INT,

Q1 INT,

Q2 INT,

Q3 INT,

Q4 INT);

INSERT INTO A

VALUES

(2017,200,250,235,266),

(2018,195,220,215,240);

SELECT *

FROM A;

XYEAR	Q1	Q2	Q3	Q4
2017	200	250	235	266
2018	195	220	215	240

SELECT XYEAR,'Q1' AS 'QQ',MAX(Q1) AS 'AMOUNT'

FROM A

GROUP BY XYEAR

UNION

SELECT XYEAR,'Q2' AS 'QQ',MAX(Q2) AS 'AMOUNT'

FROM A

GROUP BY XYEAR

UNION

SELECT XYEAR,'Q3' AS 'QQ',MAX(Q3) AS 'AMOUNT'

FROM A

GROUP BY XYEAR

UNION

SELECT XYEAR,'Q4' AS 'QQ',MAX(Q4) AS 'AMOUNT'

FROM A

GROUP BY XYEAR

ORDER BY XYEAR,QQ