how to show result set in front end as a cross table

hi..
Sql query shows result set like this
1 Process2 2012-09-01 B1 001 100
2 Process3 2012-09-02 B1 001 100
3 Process4 2012-09-03 B1 001 100
4 Process2 2012-09-01 B2 001 100
5 Process3 2012-09-02 B2 001 100
6 Process4 2012-09-03 B2 001 100
7 Process2 2012-09-01 B3 001 50
8 Process3 2012-09-03 B3 001 50
9 Process4 2012-09-04 B3 001 50
...