Hi,
Hope can anyone please help me on this predicament:

I have a raw data table showing Names versus Hours Worked as shown

Name Jan 1, Jan 2, Jan 3, Jan 4, Jan 5 €¦.
Bob 10hrs, 8hrs, 2hrs, 0hr, 1hr
Steve 8hrs, 8hrs, 8hrs, 2hrs, 2hrs
John 6hrs, 5hrs, 3hrs, 1hr, 0hr


The dates are from Jan 1 to Dec 31 (whole year) so I just cut it for
illustration purposes. My question is how to easily create a table to group
the work summaries as per the dates I want (actually based on our company
fiscal calendar range dates) or as per the date range I want€¦...

The final table should be looking like this:
Name Jan 1 ~ 15, Jan 16 ~ 20, Jan 21 ~ 30,etc
Bob ?? Hrs, ?? Hrs, ?? Hrs,
Steve ?? Hrs, ?? Hrs, ?? Hrs,
John ?? Hrs, ?? Hrs, ?? Hrs,


The date range can vary as per user's requirement, say they want work
summaries every 3 wks, forthnightly, etc

Please help! Thanks!