Distinct Values from a Datatable

[Ishan_Shelke1 (Ishan Shelke)]

Currently I have program which Generates Output from a excel like file like this

I want my Output as

Excel File :
test2.xlsx (9.6 KB)

Xaml file :
testnew.xaml (7.9 KB)

Any Answers will be greatly appreciated

[jack.chan]

refer to this @Ishan_Shelke1
testnew.xaml (12.0 KB)

logic

1. join all rows using “/”
   joinedString = String.Join("/", dt.AsEnumerable.Select(function(row) row(0).ToString).ToList)

2. split list by “/” and get distinct values
   distinctList = joinedString.Split("/"c).Distinct.tolist()

3. join list by “,”
   distinctListAsString = string.Join(",", distinctList)

output

[Yoichi]

Hi,

How about the following?

testnew.xaml (9.3 KB)

Regards,