SELECT id, ; > SUM(IIF(column_name = "January", value, 0) AS January, ; > ... > SUM(IIF(column_name = "December", value, 0) AS December ; >FROM mytable ; >GROUP BY id >