query to bind grid from database showing multiple columns based on 1 field item

[bbaamm]

he database result is as follows

DATE code class1 class2 class3
1/8/10 M1 10 20 30

3/8/10 V2 20 30 10

1/8/10 H1 1 2 3

7/8/10 !

!
8/8/10 !M2 5 5 5
3/8/10 B2 4 4 4
1/8/10 V1 3 7 3



THE OUTPUT SHOULD BE AS FOLLOWS:-

DATE M1 M2 H1 V1
C1 C2 C3 C1 C2 C3 C1 C2 C3 C1 C2 C3


1/8/10 10 20 30 5 5 5 1 2 3 3 7 3



BASED ON PARTICULAR DATE AND CODE THE DATA FROM ROWS IS DISPLAY IN THIS WAY BASED WITH MULTIPLE ROWS
CAN I GET THE QUERY TO RETRIEVE INTO THE GRID IN VB.NET USING ORACLE (TOAD)