How to assign value to NULL entry in Datatable without using for each row

[Sachin_Sreekumar]

[Sachin_Sreekumar]

It is an excel with formulas. Not as DT

[Nithinkrishna]

You mean you want to do with Excel Formula ?

[Rahul_Unnikrishnan]

Hello @Sachin_Sreekumar

Are you looking for a solution to fill the data in the value column if the value in the column is null? Is that the requirement without using the for loop?

Also what’s the value that you need to fill?

Thanks

[Sachin_Sreekumar]

Yes I need to fill data in value column as CLOSED if it is empty.
The actual excel file contains about 30k line items, some columns are formula driven.