>>Yes, it can be used to get such result but it would be slower that using IIF() aproch which works in any VFP version.
>
>Thanks. Do you have examples of each method available that you could share? Would appreciate seen them.

Hi Alex,

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