How to Get Column Value to Other Rows DataTable

Hi, Thanks for taking the time to read and help with this if possible.

I have a dataTable like this 9 see attached screenshot)
I was to get the Empty cells in the first columns filled with the same data as the very first cell
So for Col data all the empty cells should have Col1 for COl2, Col3, Col4.
Same thing when it is Dol.
Please assist

Hi @hatakora,

READ EXCEL FILE -> Dt1

  1. For each row -> row <-Dt1
  2. Check -> if(Not String.isNullEmpty(row(0).toString))
    Assign : Tempvar -> row(0).toStirng
    Else
    Write cell - “A”+(Dt1.rows.indexOf(row)+1).toString
    Value - Tempvar

Above code work for only first column. You can apply same code to other columns as well.

Thanks
Happy Automation

2 Likes

Thannks a lot @mitesh_parmar this worked

1 Like

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