MySQL 8.0

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

create table t1(id int, jobid int, description varchar(100))
insert into t1 values(1,1010,'Done'),
(2,1010,'Success'),
(3,1010,'Fail'),
(4,1020,'Status')
select jobid, 
       max(case when description in ('Done','Status') then description end) as description1,
       max(case when description in ('Success') then description end) as description2,
       max(case when description in ('Fail') then description end) as description3
from t1
group by jobid


jobid
description1
description2
description3


1010
Done
Success
Fail

1020
Status
null
null