Fetch data to single row from multiple rows

I have a table with these columns and data:

How can I fetch data such a way that only row exists for one cid and shows cr_time for step ('S02', 'S03') - like this:

You can use PIVOT technique here. The pivot can be done using GROUP BY and some aggregation function (MIN in next example) with condition within:

select 
    cid,
    min(case when step = 'S02' then cr_time end) S02_time,
    min(case when step = 'S03' then cr_time end) S03_time
from t
group by cid;

Try SQL online