C1     C2      C3      C4
A	1	2	3
B	4	5	6

CREATE TABLE A1
   (	C1 VARCHAR2(5), 
	C2 NUMBER, 
	C3 NUMBER, 
        C4 NUMBER
   );

INSERT INTO A1 VALUES ('A',1,2,3);
INSERT INTO A1 VALUES ('B',4,5,6);
COMMIT;

C1     C2
A      B
1      4
2      5
3      6

SQL> with lines as (select level line from dual connect by level <= 4),
  2       data as (select a1.*, row_number() over (order by c1) rn from a1)
  3  select max(decode(rn, 1, decode(line, 1,c1, 2,c2, 3,c3, 4,c4))) c1,
  4         max(decode(rn, 2, decode(line, 1,c1, 2,c2, 3,c3, 4,c4))) c2
  5  from lines, data
  6  group by line
  7  order by line
  8  /
C1    C2
----- -----
A     B
1     4
2     5
3     6

4 rows selected.