yogi_Pivot Data By Month And Assign Month Names To Month Numbers

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #510    Apr 18, 2012     www.energyefficientbuild.com.

user BobRoss said:
Month number to month name

Hello:

Please consider:

=query(A:C, ʺselect B, sum(C) group by B pivot month(A)ʺ)

How would I display "month(A)" (a month number taken from a date) as a month name?

Also, I'm having trouble putting the where/filter clause "where A is not null" in the right place.

Any help on these issues would be great!

Thanks!

BobRoss

-------------------------------------------------------------------------------------------------

following is a solution to the problem