Datatable empty cell fill


I need to fill the empty cells in the table… from the below image, if consecutive three cells are empty(green highlighted), then Bot needs to pick the above 3 values(yellow highlighted) and enter in respective fields. If 2 cells are empty, then bot needs to pick previous 2 values and enter. I could not use macros as excel is not installed. So I need to design this in a loop manner. Please help me with any kinds of workarounds.



Hi @soorya_prasad
if one cell is empty then u need to take the previous value to fill na ?

@NIVED_NAMBIAR , Yes. If one empty cell, I can code it easily. No complications…