I need to merge the column ‘FirstName’ and ‘LastName’ into a new column [image] Ouput: [image]

Hi @lomarnash643 Read range : Read the data into datatable Add data Column: Use add data column activity and add column ‘Name’ Use Assign activity as below DT.Columns(“Name”).Expression = “Trim([firstName]) + ’ ’ + Trim([lastName])” Use Write Range Activity Cheers…!

How to Merge 2 columns into 1 column with a space

Help Studio

Steven_McKeering (Steven McKeering) October 28, 2023, 11:49am 5

Hello

Take a look here

Cheers

Steve

1 Like

Topic		Replies	Views
LINQ Query to Merge 2 columns into 1 column with a space Activities activities , question , other	8	1683	March 13, 2023
Merge column 2 column to one column? Activities excel , activities , question	19	4091	March 18, 2022
Combine Columns to create a new column or Append all columns in first column Activities excel , activities , studio , question	16	1257	March 19, 2022
Merging two column Activities excel , activities , question	12	1571	August 28, 2021
Merging Two Columns in a CSV File Help datatable , excel , csv , activities , question	4	2469	December 9, 2019

Most Active Users - Yesterday
Anil_G
A_Learner
vrdabberu
ashokkarale
Rreddy
Jayesh_678
harshikakhatri269
xdrftww
More details...

How to Merge 2 columns into 1 column with a space

Related Topics