Hi Community I have spreadsheet which is too large/slow (15-20k rows) to use a For Each. There are multiple columns in the spreadsheet (not all columns listed below) - sample image below. Problem: I need to merge the column ‘FirstName’ and ‘LastName’ into a new column called ‘Name’. (MiddleName d…

@Steven_McKeering Updated expression to include trim as well Dt.Columns("Name").Expression = "TRIM([FirstName]) + ' ' + TRIM([LastName])" Cheers

LINQ Query to Merge 2 columns into 1 column with a space

Anil_G (Anil Gorthi) March 10, 2023, 6:41am 7

If interested try going through this

And yes expressions can be easier try and let us know the findings if you see any bottlenecks

Cheers

Topic		Replies	Views
How to Merge 2 columns into 1 column with a space Studio studio , question	5	397	October 28, 2023
Query to concat values from two columns in datatable Studio studio , question , project_panel	5	32	October 5, 2024
Modification in a LINQ query Studio datatable , studio , question , activities_panel , linq	9	625	November 17, 2022
Merge column 2 column to one column? Activities excel , activities , question	19	4453	March 18, 2022
How To append Two Cloumns in to another column in Excel using linq Activities excel	3	1336	May 15, 2022