Found a way to do the Pivot in SQL:
SELECT User, ROUND(SUM(IF(Month = 'January', Profit, NULL)),2) AS Jan, ROUND(SUM(IF(Month = 'February', Profit, NULL)),2) AS Feb, ROUND(SUM(IF(Month = 'March', Profit, NULL)),2) AS Mar, ROUND(SUM(IF(Month = 'April', Profit, NULL)),2) AS Apr, ROUND(SUM(IF(Month = 'May', Profit, NULL)),2) AS May, ROUND(SUM(IF(Month = 'June', Profit, NULL)),2) AS Jun, ROUND(SUM(IF(Month = 'July', Profit, NULL)),2) AS Jul, ROUND(SUM(IF(Month = 'August', Profit, NULL)),2) AS Aug, ROUND(SUM(IF(Month = 'September', Profit, NULL)),2) AS Sep, ROUND(SUM(IF(Month = 'October', Profit, NULL)),2) AS 'Oct', ROUND(SUM(IF(Month = 'November', Profit, NULL)),2) AS Nov, ROUND(SUM(IF(Month = 'December', Profit, NULL)),2) AS 'Dec' FROM table WHERE (YEAR(`Date Ordered`) = YEAR(NOW())) GROUP BY User;
So the only thing I still need to solve is making currency show as the whole number: e.g £10,000.00 instead of £10k