worksheet contains holiday info and looks like...

Date Name1 Name2 Name3
1/1/05
2/1/05
..
..
31/12/05

at the intersection of name & date a number 1 indicates a holiday

I'm trying to create a summary/pivot table (ultimately for use elsewhere in
the workbook) which will show...

Name,Week 1,Week 2.....
Name1,sum of hol,
Name2
Name3
....

I can't TRANSPOSE the data initially as the max no. of columns is 256 and
there are 365+ days in a year

Any suggestions much appreciated.