CREATE TABLE #TEMP(AccountNo varchar(50), Remarks varchar(50),Months int);
INSERT INTO #TEMP
VALUES ('Q49457','Abandoned',10),
('Q49457','Abandoned',11),
('Q49457','Locked-2', 9),
('Q49458','Locked',11),
('Q49458','Abandoned',10);
SELECT AccountNo,[11] AS Month11,[10] AS Month10 ,[9] AS Month9
FROM #TEMP
PIVOT(MAX(Remarks) FOR Months in( [11],[10],[9]))AS t1;
--------------------------------------
AccountNo Month11 Month10 Month9
----------------------------------------
Q49457 Abandoned Abandoned Locked-2
Q49458 Locked Abandoned NULL