Crosstab like Pivot Table

[deeds]

I have a query built...however, I need it to look like I can make a Pivot
Table look in Excel. The data set is too big to bring into Excel so I am
stuck with trying to figure this out. Here's the details:
I have 5 Row Headings, 13 value sets, each of the 12 value sets need to be
grouped by 2 headings. i.e.
Group 1
Group 2
Lab1 Lab2 Lab3 Lab4 Lab5 V1 V2 V3 V4 V1 V2 V3 V4

Hope this helps...let me know if you need more info.

Thanks in advance!

 

[KARL DEWEY]

You made an attempt to show what you wanted as output by showing some coloumn
labels.
The big thing missing is what your data looks like.

 

[deeds]

Group 1
Group 2
Lab1 Lab2 Lab3 Lab4 Lab5 V1 V2 V3 V4 V1 V2 V3 V4
Cat Dog Hat Cap Rat 10 20 30 40 50 60 70
80

Essentially I want to be able to create 12 values right now crosstab only
lets you add 1. Along with the 12 values (i.e. Sales, GM, GM %, etc) I need
to break all those 12 values into 2 groups. Hope this helps.
Thanks!