how to add data from one column to another column in same excel

[Aru]

i want to get data from one column and read it into next column in same excel…
there are multiple columns in this excel

[Palaniyappan (Forum Leader)]

Hi
Welcome to uipath community

Hope these steps could help you resolve this
— use a execl application scope and pass the file path as input
— use a read range activity and get the output with a variable of type datatable named outdt
—use a for each loop activity and pass the above variable as input
— inside which we can get the value of one column with a assign activity like this
Out_value = row(“columnname”).ToString
And assign it to another column with same assign activity like this
row(“anothercolumnname”) = Out_value

Cheers @Aru