Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 48
  • Last Modified:

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
0
tomfarrar
Asked:
tomfarrar
  • 3
  • 3
1 Solution
 
PatHartmanCommented:
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.
0
 
tomfarrarAuthor Commented:
Can this be done by query/  For instance, building queries so they are feeding off other queries?
0
 
PatHartmanCommented:
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.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
tomfarrarAuthor Commented:
Was trying to get there without creating an Access report.  So let me think about it.  Thanks.
0
 
PatHartmanCommented:
If you don't want to create a report which requires no code, then you can export the three crosstabs to specific places on the same worksheet which does require code.  Or you can create spreadsheet links to the queries and that will refresh them when the Excel template opens.  We need a better idea of what you need.
0
 
tomfarrarAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now