Issu to concat columns

[alexis.mendoza.rpa]

I have the following problem:

I’m concatenating three columns into one. The problem is that when I write the data, it deletes all subsequent columns. That is:

I concatenate columns 1, 2, and 3 into column 4, and when I write the data, it deletes columns 5 and 6.

I’m doing it this way.

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @alexis.mendoza.rpa

Try this approach and see if this helps

How To append Two Cloumns in to another column in Excel using linq

Hi @Buvaneshwaran_R Try this appraoch Read the excel using read range and store in dt1 use invoke code for writing the code by passing the dt1 as in/Out argument to the invoke code Write the below code: dt1.AsEnumerable().ToList().ForEach(Sub(r) r(“Column3”)= r(“Column1”).ToString+r(“Column2”).ToString) write the dt1 to excel using write range as well Mark it as solution if it helps you Thanks & Regards, Nived N

[Yoichi]

Hi,

In this case, it may be better to use ForEach in InvokeCode instead of LoadDataRow.
Can you try the following sample?

dt.AsEnumerable().ToList().ForEach(Sub (r)
    r(4)=r("Age").ToString().Trim()+" "+r("time").ToString().Trim()+" "+r("CD").ToString().Trim()
End Sub
)

Sample
Sample20251105-1.zip (10.5 KB)

Regards,