Fill missing data in excel - Replace "?"

[Yudhisteer_Chintaram]

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)

[Srini84 (Srinivas Kadamati)]

@Yudhisteer_Chintaram

Check below

ExcelProcess.zip (53.8 KB)

Mark as solution if this help you

Thanks

[Surya_Narayana_Korivipadu]

use read range activity to store this entire data into a datatable. Now for each row, check if row.item(“Profit”).ToString() = “?”, then assign row.item(“Profit”) = row.item(“Total”)

[Yudhisteer_Chintaram]

Thanks again!

[Surya_Narayana_Korivipadu]

Welcome. You can write the datatable back to excel sheet after these modifications. Hope it helped you.