Hi,

Keep months in column or row and then use the Group feature. To do this,
right click on the Pivot table and select Group and choose your grouping
options there.

When you use grouping, there shouldn't be any blank rows in the Pivot's
range.

Regards

Govind.

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