-- Oracle 11G New Feature - PIVOT/UNPIVOT
WITH t AS
(
SELECT CHR(LEVEL + 64) c
     , LEVEL v
  FROM dual
 CONNECT BY LEVEL <= 26
)
SELECT *
  FROM (SELECT c
             , TO_CHAR(v) v
             , CEIL(v / 7) gb1
             , MOD(v - 1, 7) + 1 x
          FROM t
        )
 UNPIVOT ( v FOR gb2 IN (c AS 1, v AS 2) )
 PIVOT ( MIN(v) FOR x IN (1 v1, 2 v2, 3 v3, 4 v4, 5 v5, 6 v6, 7 v7) )
 ORDER BY gb1, gb2
;