CREATE TABLE Sales([Year] INT,Q1 INT,Q2 INT,Q3 INT,Q4 INT);
GO
INSERT INTO Sales([Year],Q1,Q2,Q3,Q4)
VALUES (2017,12,123,324,123)
,(2018,13,455,324,878)
,(2019,29,786,473,633);
select * from Sales;
SELECT [Year],[Quarter],[Amount]
FROM Sales AS a
UNPIVOT(Amount FOR [Quarter] IN (Q1,Q2,Q3,Q4)) AS b;