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, 'Width', '121', null from dual
union all
select 1051, 'Width', '95', null from dual
union all
select 1051, 'Comments', 'Sample',  null from dual
union all
select 1170, 'Height', null, 2 from dual
union all
select 1170, 'Width', '5678', null from dual
union all
select 1170, 'Height', null, 5 from dual
6 rows affected

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


ID
WIDTH
HEIGHT
COMMENTS


1051
121,95
null
Sample

1170
5678
2,5
null


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


ID
WIDTH
HEIGHT
COMMENTS


1051
121,95
null
Sample

1170
5678
2,5
null