Tansposing Data

[gaugust]

I have an Access union query that creates the following output:

Order Type Year Month Count
1 Patient Total
25
2 Physician Agrees 2006 2 1
2 Physican Agrees 2007 2 6
3 Patient Exclusion 2007 2 10
3 Patient Exclusion 2007 3 2
4 Study Elig 2007 2
10
4 Study Elig 2007 3
2

I would like to create an excel spreadsheet in the form:
Patient Total Physician Agrees Patient
Exclusion Study Elig
25
2006
2 1
2007
2 6
10 10
3
2 2

What would be the best way to transpose this data? Would Excel automation be
the best soulution? Your suggestions would be appreciated.