Oman,

Your table may not be a pivot table, but it can be the source of the data for a pivot table. Select
the table, then use Data / Pivot Table... etc.

HTH,
Bernie
MS Excel MVP


"Oman" wrote in message
...
Thanks Bernie - my table isn't a pivot table.

One way around it is to add the quarters at the end of each set of 3
months, so:-

A1=Jan08, A2=Feb08, A3=Mar08, A4=Q1 and so on

but the trouble with this is that the formulae that feed the row data
for the months then also need to be amended for the quarter columns.

Oman