Hi I have a table in access with this format
ID Grade
1 A
5 D
6 B
1 B
5 C
need to write a query that produce the output like the format below
ID Grade1 Grade2
1 A B
5 D C
6 b
can someone please help, basically looks like the opposite of transform right?
ID Grade
1 A
5 D
6 B
1 B
5 C
need to write a query that produce the output like the format below
ID Grade1 Grade2
1 A B
5 D C
6 b
can someone please help, basically looks like the opposite of transform right?