View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BAS BAS is offline
external usenet poster
 
Posts: 14
Default Converting weeks to periods

I have a spreadsheet populated with part # usage per week for a whole year.

Weekly Usage
Part #'s Week 1 Week 2 Week 3 .... Week 52
D08... 2 7 8 22

Is there a way to convert the weeks (52) into periods (12), so Weeks 1-4
data populates into Period 1, Weeks 5-8 into Period 2, etc?

Thanks,
BAS