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)