Working on a Excel manipulation where i need

Help Studio
, ,
#1

If the item no. is same in 3rd column(ITEM#) in 2 rows then concatenate the value of (SCAN S/N here) as highlighted the value below :

image
Any help would be appreciated
Thanks in Advance.

#2

Hi @mittal.abhishek ,

Could you give this a try?

dt_sampleData.AsEnumerable().GroupBy(Function(g) g("ITEM #").ToString.Trim).Select(Function(s) dt_sampleData.Clone.LoadDataRow({String.Join(",",s.Select(Function(si) si("Scan S/N here").ToString),s.First().Item("ORDER NUMBER"),s.Key)},False)).CopyToDataTable()

I can develop a sequence for you if you could provide us with a sample dataset to work with.

Kind Regards,
Ashwin A.K

#3

Thanks for providing the solution but i have applied other logic to handle the scenario.

Thanks.