Can we concatenate two column names instead of taking column values?
Hi @Sai_Kumar7, welcome to the Community.
Can you please share a sample input & expected output, so that we can analyze your requirements?
I hope this will help you,
Read range workbook to read the excel
Take for each row in datatable
row(“NewColumnName”) = row(“Column1Name”).ToString + row(“Column2Name”).ToString
After use write range workbook activity.
You should be using the cell number not the columns here in excel formula