Crosstab like Pivot Table

  • Thread starter Thread starter deeds
  • Start date Start date
D

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!
 
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.
 
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!
 
Back
Top