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