Hi, in SQL I want to display data in the below format

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