Oracle 18c

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

create table your_table (id, fieldname, text, num) as
select 1051, 'Comments', 'FP-SK/124',  null from dual
union all
select 1051, 'Width', '121', null from dual
union all
select 1051, 'Height', null, 2 from dual
union all
select 1170, 'Width', '5678', null from dual
union all
select 1170, 'Height', null, 5 from dual
5 rows affected

select *
from your_table
pivot (
  max(coalesce(text, to_char(num)))
  for (fieldname) in ('Width' as width, 'Height' as height, 'Comments' as comments))


ID
WIDTH
HEIGHT
COMMENTS


1051
121
2
FP-SK/124

1170
5678
5
null


select id,
  max(case when fieldname = 'Width' then text end) as width,
  max(case when fieldname = 'Height' then num end) as height,
  max(case when fieldname = 'Comments' then text end) as comments
from your_table
group by id


ID
WIDTH
HEIGHT
COMMENTS


1051
121
2
FP-SK/124

1170
5678
5
null