this might help…
https://bobj-board.org/t/138394
or if you want to do this at database level below link might help
http://www.blog.arun-prabha.com/2009/02/23/oracle-sql-converting-multiple-rows-into-single-row/
sati_sunil (BOB member since 2010-09-16)