Hello , Here I mentioned the sample input of my reqirement, where I need to find duplicate in “RollNo” and get thier corresponding values in Column “Name” and Add the string into single cell of Column “Name” Input [image] Output (required) Name,RollNo Ajay,1 Dinesh Siva,5 Siva,2 Pradeep,4 …

Assumption - dtResult = BuildDT.Clone or prepared datatable with e.g. build datatable we can simplify to (From d In BuildDT.AsEnumerable() Group d By k=d("RollNo").toString().Trim() Into grp = Group Let nj = String.Join(",", grp.Select(Function (n) n("Name").toString.Trim)) Let ra = new Object(){…

Need Linq for Find duplicate data and merge the corresponding data of other cell

Help Studio

Gokul_Jayakumar (Gokul Jai) August 30, 2022, 12:24pm 4

@ppr @Sanjit_Pal , Thanks for your valuable inputs.

Topic		Replies	Views
LinQ to find duplicates Studio studio , question , activities_panel	3	1012	August 5, 2023
Get all duplicates and add to single column in datatable Studio	2	771	September 19, 2020
Is it possible? Datatable matching duplicates using linq Studio studio , question , activities_panel	13	928	July 30, 2022
Combine Duplicate row value into Single row Studio	13	1256	August 30, 2022
Remove Duplicates with LinQ Help studio	17	18008	October 29, 2018

Need Linq for Find duplicate data and merge the corresponding data of other cell

Related topics