Columns to Rows

[mohabi]

Hi

I would highly appreciate if someone can help with this:

I was working on a database in MS Access and I have encountered an issue I
need your assistance with. I have a table for which i would like to convert
the data from Column to Rows. Except for the Month field in Date format all
fields are in text format. Even though Pivot is good representation of what I
want but it does not work the way I need it. I want to be able to modify the
data in Pivot but it does not allow me to. So far I have tried Cross tabs but
this gives me blank fields if I use GroupBy or missing data if I use First.

Here is an example of my table:

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 if I use Group by. Or even though there is a spot available on
the previous row for the same type for some reason it puts the data into the
2nd line for which I later have to manually cut paste the data into the upper
row.

I cannot use pivot feature of Access 2003 because I cannot edit it.

Your suggestion would be highly appreciated.

 

[ryguy7272]

I think a Pivot Table will work. I just tried it; seemed to work just fine.
Type in 'Row', Month in 'Column', and Name in 'Data Fields'.

Try it again and see how you get along.

Good luck,
Ryan---