Transpose Data query - MS Access

[deepakes2]

How Can I transpose the Following:

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
3 6 R

desired output

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

Crosstab Query and Pivot returning only one row.

In this case only one row associated with ID:1

There are multiple records in the table like ID:1 this which i need to display in output table in multiple rows.

The ID:1 taken courses multiple times . In the output I have to show all the data that is in the raw input table.
The ID:2 Taken Courses and i have to display what ever data is available in the input table to output table.
I hope you understand .


Thank you

 

[Ranman256]

use the query wizard

 

[deepakes2]

Query wizard is not working . returning only one value

In this case only one row associated with ID:1

not able to show other rows associated with the ID. I have numerous records like ID:1 . I have to display all the records in the output.