Wednesday, April 18, 2012

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

user BobRoss said:
Month number to month name
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!
following is a solution to the problem