SQL Table Row Data show in column data

 SELECT *  
 FROM (SELECT CAST(mlblmsg AS varchar(max)) AS mlblmsg,clblcode FROM warninglabels) t  
 PIVOT (MAX(mlblmsg)  
 FOR clblcode IN ([0001],[0002],[003],[0004],[0005],[0006]))p