Pivot Table

Headers on your two columns - DATE & VALUE
Select all your data, do Data / Pivot table & Chart Report, hit Next / Next
/ Finish

Drag DATE to the ROW fields
Right click on any of the dates and select GROUP & SHOW DETAIL
Select Months (already selected) and Years (Just click it as well) - Both
will appear in Blue - Hit OK
On the table, drag the YEARS field that just appeared into the top of the
table where it is marked COLUMN fields
Drag VALUE into the DATA area - Right click on any of the values, choose
field settings and from the list on the left of the dialog box, select
AVERAGE.

Done.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Kaine" wrote in message
...
Does any one know an easy way to convert a series of weekly data into
their
respective monthly averages.

I have a large range of data in weekly format:
1/2/99 3.54
8/2/99 5.41
15/2/99 2.10

through to...
25/2/05 4.10

How can i get that data into a table which looks like:
1999 2000 ....... 2005
Jan 5.12 1.24 ...... 5.28
Feb 2.14 3.54 ....... 1.79
Mar etc etc
....
Dec 2.45 4.8 ........ #NA

The monthly average table needs to look up the respective months in the
weekly data and average them into the corresponding cell (ie Jan-1999
equals
5.12 from the 4 or so weeks of data).

I am thinking vlookup function, but am unsure how to add average when
looking up a series of dates in a lookup function.
I already have a similar table which looks up the week number of the date
and puts the corresponding weekly data into the table against its week
number.

The weekly data may also have returned #na for graphing purposes, is there
anyway i can accommodate this in the formula.

I would appreciate some help.