Oracle 21c

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

CREATE TABLE mytable (
  rec_no NUMBER,
  f_id	 NUMBER,
  f_value varchar2(20)
);


insert into mytable (rec_no, f_id, f_value)
          select 1,	1502,	'text1' from dual
union all select 1,	1503,	'text2' from dual
union all select 2,	1502,	'text3' from dual
union all select 2,	1503,	'text4' from dual
union all select 2,	1508,	'text5' from dual
union all select 1,	1509,	'text6' from dual
union all select 1,	1508,	'text7' from dual
union all select 2,	1509,	'text8' from dual
8 rows affected

SELECT
    rec_no,
    MAX(DECODE(f_id, 1502, f_value)) "1502",
    MAX(DECODE(f_id, 1503, f_value)) "1503",
    MAX(DECODE(f_id, 1508, f_value)) "1508",
    MAX(DECODE(f_id, 1509, f_value)) "1509"
FROM mytable
GROUP BY rec_no
ORDER BY rec_no;


REC_NO
1502
1503
1508
1509


1
text1
text2
text7
text6

2
text3
text4
text5
text8