Pivot Tables Multiple Consolidation Ranges

In searching for a method to unpivot a series of data, I found out about the Multiple Consolidation Ranges. Problem is that I need to include more data to produce a list without extra copy pasting. The data will be imported to Access.
[tt]
Data
22 23 24 ...
01/05/08 01/10/08 01/15/08 ...
XYZ Group1 5 5 7
XYZ Group2 4 4 6
XYZ Group3 0 0 2
ABC Group1 19 22 23
ABC Group2 19 19 19
ABC Group3 0 0 1



I was able to get it to look like this by Concatenating Col A and Col B into a new Col C:

XYZ GROUP1 01/05/08 5
XYZ GROUP1 01/10/08 5
XYZ GROUP1 01/15/08 7
XYZ GROUP2 01/05/08 4
XYZ GROUP2 01/10/08 4
XYZ GROUP2 01/15/08 6
XYZ GROUP3 01/05/08 0
XYZ GROUP3 01/10/08 0
XYZ GROUP3 01/15/08 2

However, I still need to add row 1 so that result looks like:

Prog Group Wk RunDate Total
--- ------ -- -------- --
XYZ GROUP1 23 01/05/08 5
XYZ GROUP1 24 01/10/08 5
XYZ GROUP1 25 01/15/08 7
XYZ GROUP2 23 01/05/08 4
XYZ GROUP2 24 01/10/08 4
XYZ GROUP2 25 01/15/08 6
XYZ GROUP3 23 01/05/08 0
XYZ GROUP3 24 01/10/08 0
XYZ GROUP3 25 01/15/08 2

Can this be done? Also can it be done without me having to concatenate Col A and B as well (As I have a lot of data to transform)?
[/tt]