WITH t AS
(
SELECT '2014/07/06' dt, 10.1 v1, 10.1 v2, 10.1 v3, 10.1 avg, 30.3 tot FROM dual
UNION ALL SELECT '2014/07/07', 10.2, 10.2, 10.2, 10.2, 30.6 FROM dual
UNION ALL SELECT '2014/07/08', 10.3, 10.3, 10.3, 10.3, 30.9 FROM dual
)
SELECT DECODE(lv, 1, 'dt'
                , 2, 'v1'
                , 3, 'v2'
                , 4, 'v3'
                , 5, 'avg'
                , 6, 'tot'
                ) gb
     , MIN(DECODE(rn, 1, v)) v1
     , MIN(DECODE(rn, 2, v)) v2
     , MIN(DECODE(rn, 3, v)) v3
  FROM (SELECT lv
             , rn
             , DECODE(lv, 1, dt
                        , 2, TO_CHAR(v1)
                        , 3, TO_CHAR(v2)
                        , 4, TO_CHAR(v3)
                        , 5, TO_CHAR(avg)
                        , 6, TO_CHAR(tot)
                        ) v
          FROM (SELECT ROW_NUMBER() OVER(ORDER BY dt) rn
                     , dt, v1, v2, v3, avg, tot
                  FROM t)
             , (SELECT LEVEL lv FROM dual CONNECT BY LEVEL <= 6)
        )
 GROUP BY lv
 ORDER BY lv
;