Tom Farrar
asked on
How can I get the cross tab shown in the example from table shown in example?
Please see the attached sheet. Is there a way in Excel, Access or other to get from table on the left to cross-tab on the right? This is just an example. The actual table is more than 1MM rows. Thanks.
EE.xlsx
EE.xlsx
On the right are THREE crosstabs not one. You just have to create them one at a time. If you want them all on the same report, embed them as subreports.
ASKER
Can this be done by query/ For instance, building queries so they are feeding off other queries?
You can create the three separate crosstabs and then a fourth query that joins the three crosstabs. That will get all the columns on the same line but that isn't what the example shows.
ASKER
Was trying to get there without creating an Access report. So let me think about it. Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.