Automatically split weekly data into monthly totals

[solo9999]

Hi all,

I have the following setup:

52 weeks of 2010 cost with the following structure:

week number | wk1 | wk2 | wk3
week ending | 1/10/2010 | 1/17/2010 | 1/24/2010
weekly cost | 57,000 | 35,000 | 42,000

I want to be able to use the above data to present a summary, but instead of weekly, list the data on a monthly basis:

month | Jan | Feb | Mar
monthly cost | wk1-4 | wk5-8 | wk9-12+3days wk13


I hope you can understand what I mean So, is there a way to set this up automatically instead of having to split the weekly data as many months share the same weeks?

Thanks!

 

[Special-K99]

Pivot table?

 

[solo9999]

Pivot table?

Any pointers? Can't seem to get it working.