Access Access Rows to Columns

[mohabi]

Hi

I have a table like this:

Type Name Month
A PersonA Jan-10
A PersonA May-10
A PersonA Jun-10
A PersonB Apr-10
A PersonC Apr-10
B PersonD Jan-10
B PersonD Feb-10
B PersonA Mar-10
B PersonA Apr-10
B PersonB May-10
B PersonB Jun-10
B PersonC May-10
B PersonC Jun-10
B PersonE Jan-10
C PersonF Mar-10
D PersonG Jan-10
D PersonG Feb-10
D PersonG Mar-10
D PersonG Apr-10
D PersonG May-10
D PersonG Jun-10
D PersonH Jan-10
D PersonH Feb-10
D PersonH Mar-10
D PersonH Apr-10
D PersonH May-10
D PersonH Jun-10
D PersonI Jan-10
D PersonI Feb-10
D PersonI Mar-10
D PersonI Apr-10
D PersonI May-10
D PersonI Jun-10
E Personj Jan-10
E Personj Feb-10
E Personj Mar-10
E Personj Apr-10
E Personj May-10
E Personj Jun-10

Want to convert into a table like this:
Type Jan-10 Feb-10 Mar-10 Apr-10 May-10 Jun-10
A PersonA PersonB PersonA PersonA
A PersonC
B PersonD PersonD PersonA PersonA PersonB PersonB
B PersonE PersonC PersonC
C PersonF
D PersonG PersonG PersonG PersonG PersonG PersonG
E PersonH PersonH PersonH PersonH PersonH PersonH
E Personi Personi Personi Personi Personi Personi

I tried Cross tab query - but this gives me the result for each name as a separate row when I use Group by.
I cannot use pivot feature of Access 2003 because I cannot edit it.
Appreciate your help.