Need to apply concatenate formula in an excel with 50,000 rows

[lakshman (Ganta lakshman)]

@Boopathi

Use Invoke Method activity to do this. Please check below thread for your reference.

How to concatenate two columns in datatable without looping and keep concatinated data in new column?

The expected result is single column table with same three rows but two column merged into single column like (A1-b1, a2-b2, a3-b3)