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

[Sanjit_Pal]

Hey @Gokul_Jayakumar,

You can use the below code,

(From row In dt1.AsEnumerable
	Group row By key = New With { 
	Key.name = row.Item("Name")} Into grp = Group
	Select dt1Clone.LoadDataRow(New Object() {
		key.name,
		String.Join(" ",grp.Select(Function(x)x("Address").ToString).ToArray)
	}, True)).CopyToDataTable

Thanks,
Sanjit