Dynamic Excel Fill


I have an excel file as shown below:

I need to concatanate the row such that I need to check if I have a similar “License Plate” above and fill in the time in/out and weight in/out as shown below:


So each entry has either time in - weight in OR time out- weight out.

I need to fill the blanks of each pair license plate rows.

Can someone help me please?
UIPath_Excel_Scratch.xlsx (118.4 KB)

@prasath_S , @NIVED_NAMBIAR @Shraddha_Gore , can any of you guys please help?
I am really desperate.