How to separate data to another colum at table?

Posted 18 March 2013 - 01:03 AM

example my data in oracle:
----------------------
| col1 | col2 | col3 |
----------------------
| A | 1 | 1 |
| A | 2 | 2 |
| B | 3 | 3 |
| B | 4 | 4 |
| C | 5 | 5 |
| C | 6 | 6 |
----------------------

table result on my web page is:
----------------------
| out1 | out2 | out3 |
----------------------
| A | | |
| B | | |
| C | | |
----------------------

the result that i want is the data should be like this:
----------------------
| out1 | out2 | out3 |
----------------------
| A | B | C |
| A | B | C |
----------------------