Hello,
I have the excel where I need to check if we have missing value in the column “Profit”. The missing value is denoted by a “?” as shown below. I then need to replace the value “?” only in the “Profit” column by the value in the “Total” column.
Raw Data:
Preprocessed Data:
Can anyone help me please?
thanks!
UIPath_Excel_Scratch (4).xlsx (20.2 KB)