How to Get Column Value to Other Rows DataTable

[hatakora (Hamdy Atakora)]

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

[mitesh_parmar]

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

[hatakora (Hamdy Atakora)]

Thannks a lot @mitesh_parmar this worked