I have to replace the empty values in Column1 with the corresponding values from Column2 in the datatable. Considering the number of records, i dont want to use foeach loop. How we can achieve that without using foreach loop?
Column1 | Column2 | Column3 |
---|---|---|
AA | AB | AC |
BB | BC | |
CA | CB | CC |
DB | DC |