WITH t_test AS
(
SELECT 'JONES' t_name, 'A1' t_val, 1 t_ord FROM dual
UNION ALL SELECT 'JONES', 'A2',  2 FROM dual
UNION ALL SELECT 'JONES', 'A3',  3 FROM dual
UNION ALL SELECT 'JONES', 'A4',  4 FROM dual
UNION ALL SELECT 'JONES', 'A5',  5 FROM dual
UNION ALL SELECT 'JONES', 'A6',  6 FROM dual
UNION ALL SELECT 'JONES', 'A7',  7 FROM dual
UNION ALL SELECT 'CASEY', 'B1', 11 FROM dual
UNION ALL SELECT 'CASEY', 'B2', 12 FROM dual
UNION ALL SELECT 'CASEY', 'B3', 13 FROM dual
UNION ALL SELECT 'CASEY', 'B4', 14 FROM dual
UNION ALL SELECT 'CASEY', 'B5', 15 FROM dual
)
SELECT t_name
     , y
     , MIN(DECODE(x, 1, t_val)) col1
     , MIN(DECODE(x, 2, t_val)) col2
     , MIN(DECODE(x, 3, t_val)) col3
     , MIN(DECODE(x, 4, t_val)) col4
     , MIN(DECODE(x, 5, t_val)) col5
  FROM (SELECT t_name, t_val
             , CEIL(rn / 5) y
             , MOD(rn - 1, 5) + 1 x
          FROM (SELECT t_name, t_val
                     , ROW_NUMBER() OVER(PARTITION BY t_name ORDER BY t_ord) rn
                  FROM t_test
                )
        )
 GROUP BY t_name, y
 ORDER BY t_name, y
;
-- PIVOT 11G --
SELECT *
  FROM (SELECT t_name, t_val
             , CEIL(rn / 5) y
             , MOD(rn - 1, 5) + 1 x
          FROM (SELECT t_name, t_val
                     , ROW_NUMBER() OVER(PARTITION BY t_name ORDER BY t_ord) rn
                  FROM t_test
                )
        )
 PIVOT (MIN(t_val) FOR x IN (1, 2, 3, 4, 5))
 ORDER BY t_name, y
;