Fill missing data in excel - Replace "?"


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?

UIPath_Excel_Scratch (4).xlsx (20.2 KB)

1 Like


Check below (53.8 KB)

Mark as solution if this help you


1 Like

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”)

1 Like

Thanks again!

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.