Fromatting Export to Excel from web app/sql

Question

I am exporting several sets of data from sql via a web app to Excel.  Is it possible to format this data.  In particular I would like to use the "Subtotal" function in Excel using "sum" at each change in Shift Set.  Below is an example of what the spreadsheet looks like.  In this case I would like columns "Employees" through "Sat" to be summed twice: once for shit set 6 and once for shift set 7. 

ScheduleHeaderID	Date	TotalEmployees	TotalShifts	DisplayName	Minimum	Maximum	NeededMon	NeededTues	NeededWed
288	6/4/2010 9:14	57	251	6/4/2010 - 57 emps	51	62	40	45	38
Shift Set	Shift ID	Employees	SUN	MON	TUE	WED	THU	FRI	SAT
6	155	14	14	14	14	0	0	14	0
6	136	17	0	0	17	17	17	17	0
6	162	5	5	5	5	0	5	5	0
6	152	9	9	9	0	9	9	9	0
6	171	12	12	12	12	12	12	0	0
7	155	14	14	14	14	0	0	14	0
7	136	17	0	0	17	17	17	17	0
7	162	5	5	5	5	0	5	5	0
7	152	9	9	9	0	9	9	9	0
7	171	12	12	12	12	12	12	0	0