>>Here's IIF method.

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
>>

>
>The other method makes it possible to write generic code, I believe.

I don't see how.