with t as
(select 1 c1, 'val1' c2, 'val6' c3,  'val11' c4 from dual union all
 select 2 c1, 'val2' c2, 'val7' c3,  'val12' c4 from dual union all
 select 3 c1, 'val3' c2, 'val8' c3,  'val13' c4 from dual union all
 select 4 c1, 'val4' c2, 'val9' c3,  'val14' c4 from dual union all
 select 5 c1, 'val5' c2, 'val10' c3, 'val15' c4 from dual
)

select v1, v2, v3, v4, v5
from t
pivot(max(c2) as c2, max(c3) as c3, max(c4) as c4 for c1 in (1 as v1, 2 v2, 3 v3, 4 v4, 5 v5))
unpivot((v1, v2, v3, v4, v5) for gb in ((v1_c2, v2_c2, v3_c2, v4_c2, v5_c2)
                                      , (v1_c3, v2_c3, v3_c3, v4_c3, v5_c3)
                                      , (v1_c4, v2_c4, v3_c4, v4_c4, v5_c4) ) )
;

WITH T AS
(
SELECT '1' COL1 , 'value1' COL2 , 'value6' COL3, 'value11' COL4 FROM DUAL UNION ALL
SELECT '2' COL1 , 'value2' COL2 , 'value7' COL3, 'value12' COL4 FROM DUAL UNION ALL
SELECT '3' COL1 , 'value3' COL2 , 'value8' COL3, 'value13' COL4 FROM DUAL UNION ALL
SELECT '4' COL1 , 'value4' COL2 , 'value9' COL3, 'value14' COL4 FROM DUAL UNION ALL
SELECT '5' COL1 , 'value5' COL2 , 'value10' COL3, 'value15' COL4 FROM DUAL
)
SELECT A, B, C, D, E FROM
(
SELECT GB, VAL, RN
FROM (SELECT COL1 ,COL2 ,COL3, COL4, ROWNUM RN FROM T)
UNPIVOT ( VAL FOR GB IN (COL1 AS 1, COL2 AS 2 ,COL3 AS 3, COL4 AS 4))
)
PIVOT(MAX(VAL) FOR RN IN (1 A,2 B ,3 C, 4 D, 5 E))