I have data that is organized by a group and method in which these numbers are processed. It looks like this:
Number Group Method 100-A Alpha Auto 100-B Alpha Auto 100-C Alpha None 100-D Alpha Manual 101-DA Alpha Manual 100-B Alpha None 171 - CD Omega Auto 171 -B48 Omega Auto 551-3 Beta Manual 4829-1 Beta Manual 3424 beta Manual
Now, I want the data to look like this when I run a query in Access:
Group Auto
Manual None Alpha
2
2 2 Omega
2
0 0 Beta
0
3 0
How can I do that? Thanks
Note the formatting on the second table is a bit weird, but I think you all know where I'm getting at.