How could I merge 2 values of 2 columns and transfer them to a new column?

you can use write cell activity to write the formula to the excel and then use auto fill range activity to apply on all rows

1 Like