Hi all

I have data with the following structure (column headings):

Category Brand Group M1 M2 M3... M12

where M1 is month 1, M2 is month 2, etc.

I would like a pivot table that I can manipulate in different ways to
show totals by month, quarter and year. Question is, can I keep the
months in columns to do this, or do I need a different row for each
month?

Thanks in advance

Paul Martin
Melbourne, Australia