Solved

How can I get the cross tab shown in the example from table shown in example?

Posted on 2016-09-21
6
36 Views
Last Modified: 2016-10-26
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
Comment
Question by:tomfarrar
  • 3
  • 3
6 Comments
 
LVL 35

Expert Comment

by:PatHartman
ID: 41809690
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
 
LVL 7

Author Comment

by:tomfarrar
ID: 41832874
Can this be done by query/  For instance, building queries so they are feeding off other queries?
0
 
LVL 35

Expert Comment

by:PatHartman
ID: 41833838
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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 7

Author Comment

by:tomfarrar
ID: 41845936
Was trying to get there without creating an Access report.  So let me think about it.  Thanks.
0
 
LVL 35

Accepted Solution

by:
PatHartman earned 500 total points
ID: 41846080
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
 
LVL 7

Author Closing Comment

by:tomfarrar
ID: 41860682
Thanks.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now