WITH tmp AS (
SELECT '2' a,'0900' b FROM DUAL UNION ALL
SELECT '2' a,'1000' b FROM DUAL UNION ALL
SELECT '2' a,'1300' b FROM DUAL UNION ALL
SELECT '2' a,'1600' b FROM DUAL UNION ALL
SELECT '3' a,'1000' b FROM DUAL UNION ALL
SELECT '3' a,'1100' b FROM DUAL UNION ALL
SELECT '4' a,'0900' b FROM DUAL UNION ALL
SELECT '4' a,'0930' b FROM DUAL UNION ALL
SELECT '4' a,'0950' b FROM DUAL UNION ALL
SELECT '5' a,'1100' b FROM DUAL UNION ALL
SELECT '5' a,'1300' b FROM DUAL UNION ALL
SELECT '6' a,'1700' b FROM DUAL
)
SELECT MAX("2") AS "2"
,MAX("3") AS "3"
,MAX("4") AS "4"
,MAX("5") AS "5"
,MAX("6") AS "6"
FROM (
SELECT DECODE(a,'2',b) "2"
,DECODE(a,'3',b) "3"
,DECODE(a,'4',b) "4"
,DECODE(a,'5',b) "5"
,DECODE(a,'6',b) "6"
,ROW_NUMBER() OVER(PARTITION BY A ORDER BY B) rn
FROM tmp
)
GROUP BY RN
ORDER BY RN