Grouping based on a field

I have 4 columns namely client, stage1,stage2, time with values for ex: 1233, pass,na, 12-02-2023 and 1233, na, pass, 13-02-2023. I would like to see an output in the form of table similar to 1233, pasa, pass, 13-02-2023. Can someone help me with this?

Note: Im getting different log for different stages hence na is populated but once stage 2 is completed it means that 1 is also completed

Can you make an ifelse column that you use for stage one?

ifelse({stage2}=‘pass’,‘pass’,{stage1}) That’s the only thing you want to change right?