Access Transpose Query Help

[deepakes2]

I have a questions.


Can you help me write a query in Access to transpose the data


Table : Transpose
ID score course
1 3 M
1 4 C
1 T
1 4 E
1 4 M
1 5 C
1 2 T
2 M
2 3 T
2 5 E
2 11 R
3 3 M
3 4 C


desired output


ID M C T E R ..
1 3 4 - 4 -
1 4 5 2 - -
2 - - 3 5 11
3 3 4 - - -




Thank you for ur help. Thanks

[ranman256]

use the query wizard. It will ask you what rows you want,
then what columns, then the data in the middle.
Very Easy.

[deepakes2]

The Query Wizard is not helping I need to keep the duplicates associated with the ID.
Example : from the above table ID:1 has two sets of values need to be displayed in the output table.

Plz try it .. Its not simple as it sounds .. at least not easy for me .

Thanks -