Перевернуть запрос ORACLE

WITH t_print AS
 (SELECT t.prof,
         CASE
           WHEN t.prof = 'ВЕДУЩИЙ ЭКОНОМИСТ' THEN
            t1
           WHEN t.prof = 'ЭКОНОМИСТ' THEN
            t2
           WHEN t.prof = 'ИНЖЕНЕР' THEN
            t3
           WHEN t.prof = 'Кладовщик' THEN
            t4
         END AS id_rule
    FROM sp_print_employee t
   WHERE t.podr = 83
     AND t.prz_act = 1)
 (SELECT id_rule
    FROM t_print
   WHERE t1 = 'ВЕДУЩИЙ ЭКОНОМИСТ' AS fio) r1 inner join
 (SELECT id_rule FROM t_print WHERE t2 = 'ЭКОНОМИСТ' AS fio) r2 ON r2.fio = r1.fio inner join
 (SELECT id_rule FROM t_print WHERE t3 = 'ИНЖЕНЕР' AS fio) r3 ON r3.fio = r1.fio inner join
 (SELECT id_rule FROM t_print WHERE t4 = 'КЛАДОВЩИК' AS fio) r4 ON r4.fio = r1.fio

WITH t_print AS
 (SELECT t.fio,
         CASE
           WHEN t.prof = 'ВЕДУЩИЙ ЭКОНОМИСТ' THEN
            1
           WHEN t.prof = 'ЭКОНОМИСТ' THEN
            2
           WHEN t.prof = 'ИНЖЕНЕР' THEN
            3
           WHEN t.prof = 'КЛАДОВЩИК' THEN
            4
         END AS id_role
    FROM sp_print_employee t
   WHERE t.podr = 83
     AND t.prz_act = 1)
SELECT t1 AS ved_econ, t2 AS econ, t3 AS engen, t4 AS klad FROM 
(SELECT t1.fio, ROWNUM AS rw FROM t_print t1 WHERE t1.id_role = 1) r1 left join 
(SELECT t2.fio, ROWNUM AS rw FROM t_print t2 WHERE t2.id_role = 2) r2 ON r2.fio = t1.fio left join
(SELECT t3.fio, ROWNUM AS rw FROM t_print t3 WHERE t3.id_role = 3) r3 ON r3.fio = t1.fio left join 
(SELECT t4.fio, ROWNUM AS rw FROM t_print t4 WHERE t4.id_role = 4) r4 ON t4.fio = t1.fio

SELECT MAX(ved_econ) AS ved_econ,
       MAX(econ) AS econ,
       MAX(engine) AS engine,
       MAX(klad) AS klad
  FROM (WITH t_print AS (SELECT t.fio,
                                CASE t.prof
                                  WHEN 'ВЕДУЩИЙ ЭКОНОМИСТ' THEN 1
                                  WHEN 'ЭКОНОМИСТ' THEN 2
                                  WHEN 'ИНЖЕНЕР' THEN 3
                                  WHEN 'КЛАДОВЩИК' THEN 4 
                                END AS id_role,
                                t.id
                           FROM sp_print_employee t
                          WHERE t.podr = 83
                            AND t.prz_act = 1)
SELECT ved_econ, econ, engine, klad FROM sp_print_employee t left join 
(SELECT t1.id, t1.fio AS ved_econ, ROWNUM AS rw FROM t_print t1 WHERE t1.id_role = 1) r1 ON t.id = r1.id left join 
(SELECT t2.id, t2.fio AS econ, ROWNUM AS rw FROM t_print t2 WHERE t2.id_role = 2) r2 ON t.id = r2.id left join 
(SELECT t3.id, t3.fio AS engine, ROWNUM AS rw FROM t_print t3 WHERE t3.id_role = 3) r3 ON t.id = r3.id left join 
(SELECT t4.id, t4.fio AS klad, ROWNUM AS rw FROM t_print t4 WHERE t4.id_role = 4) r4 ON t.id = r4.id)

SELECT MAX(DECODE(prof, 'ВЕДУЩИЙ ЭКОНОМИСТ', fio)) lead_econ,
       MAX(DECODE(prof, 'ЭКОНОМИСТ', fio)) econ,
       MAX(DECODE(prof, 'ИНЖЕНЕР', fio)) engineer,
       MAX(DECODE(prof, 'КЛАДОВЩИК', fio)) stockman
  FROM (SELECT t.fio,
               t.prof,
               ROW_NUMBER() OVER(PARTITION BY prof ORDER BY fio) rn
          FROM sp_print_employee t
         WHERE t.podr = 83
           AND t.prz_act = 1)
 GROUP BY rn