Pivot Table Question

[srizki]

I need to create a pivot table. My headings are in A3 toAE3, and the data is in A4:AE462.
Here is the problem; at the end of the table I have headingthat repeated,
[TABLE="width: 242"]
<tbody>[TR]
[TD="width: 65"]

3900​

[/TD]
[TD="width: 65"]

3910​

[/TD]
[TD="width: 65"]

3940​

[/TD]
[TD="width: 65"]

3980​

[/TD]
[TD="width: 65"]

TOTAL​

[/TD]
[/TR]
</tbody>[/TABLE]
Three times and thenand there is another heading on top of each of the three groups. COMBINE,WORKING INTERES, RETAIN INTEREST. Each of these headings are on top of each ofthe groups from L2:P2, Q2:U2, V2:Z2,
Can I create a Pivot table? Or can it be done usingPowerPivot?
Please advice,
Thanks