Solved I need to move Access data to a Excel Matrix

May 9, 2015 at 04:57:24
Specs: Windows 7, 32G
I have 3 rows of data in Access

Capability System Data
Cap 1 Sys 1 X
Cap 3 Sys 2 P
Cap 1 Sys 3 x
Cap 2 Sys 1 x

How do I move that to an Excel Matrix with Capabilities listed in Column A and Systems listed across the top. The appropriate cells should be marked with an X or a P.


See More: I need to move Access data to a Excel Matrix

Report •


#1
May 9, 2015 at 10:08:56
In your spreadsheet, click on Data on the ribbon, then click From Access. Then, just follow the prompts and create your Matrix as desired.

Report •

#2
May 13, 2015 at 17:21:18
✔ Best Answer
Well, that wasn't helpful. I figured it out. It is called a Crosstab Query.

Under the Create tab, click on Query Wizard and select Crosstab Query. From there, you can just follow the prompts to create a 2-dimensional matrix with capabilities listed on the side and Systems listed across the top. The data, or X's, are put into the appropriate square.


Report •

Related Solutions


Ask Question