Excel Sheet Modification

Help Activities
, ,
2

Hi @sunain_chahar

Try this approach

image

dt_Output=

(
	From row In dt_Data
	Group row By
	k1= row("Sold to party").ToString.Trim,
	k2=row("Bill doc").ToString.Trim
	Into grp=Group
	Select dt_Data.LoadDataRow({k1, k2, String.Join("/", grp.Select(Function(gr) gr("invoice no").ToString.Trim))}, True)
).CopyToDataTable

Output

image

Please refer the xaml

LINQ_GroupByConcatColumnValue.xaml (5.4 KB)