Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test(c1 number,
                  c2 number,
                  c3 number,
                  c4 number,
                  c5 number);

insert into test (c1,c2,c3,c4,c5) values(2000,1844054,50.03,922030,25.01)
1 rows affected

insert into test (c1,c2,c3,c4,c5) values(2001,1850861,49.86,937391,25.25)
1 rows affected

insert into test (c1,c2,c3,c4,c5) values(2002,1841519,50.32,907995,24.81)
1 rows affected

insert into test (c1,c2,c3,c4,c5) values(2003,1804163,49.84,902838,24.94)
1 rows affected

select which,
       max(case when year = 2000 then c end) as val_2000,
       max(case when year = 2001 then c end) as val_2001,
       max(case when year = 2002 then c end) as val_2002,
       max(case when year = 2003 then c end) as val_2003
from ((select c1 as year, 'c2' as which, c2 as c from test) union all
      (select c1 as year, 'c3' as which, c3 as c from test) union all
      (select c1 as year, 'c4' as which, c4 as c from test) union all
      (select c1 as year, 'c5' as which, c5 as c from test) 
     ) x
group by which
order by which


WHICH
VAL_2000
VAL_2001
VAL_2002
VAL_2003


c2
1844054
1850861
1841519
1804163

c3
50.03
49.86
50.32
49.84

c4
922030
937391
907995
902838

c5
25.01
25.25
24.81
24.94

WHICH	VAL_2000	VAL_2001	VAL_2002	VAL_2003
c2	1844054	1850861	1841519	1804163
c3	50.03	49.86	50.32	49.84
c4	922030	937391	907995	902838
c5	25.01	25.25	24.81	24.94