Morning all I have this table in SQL (2005), generated by a third party and cannot be changed... T1, T2, T3 and T4 are monthly targets. In reality this table is around 250 rows. A different third party needs to access this data in a different format; a new table is fine. I needs it to look like... I did something similar many, many moons ago using a PIVOT in SQL but cannot for the life of me apply what I learned way back when to this. I'm not saying a PIVOT is the best way to go about this. Any ideas or suggestions would be awesome. Cheers!