Can someone please help me how to filter data excel and save it to a new excel file

from this one
to this one

Could you please elaborate on your requirement?


If your input is as the following,


Is the result the following right?


If so, the following will work.

  dict = dtSrc.AsEnumerable.GroupBy(Function(r) r("Employee ID").ToString).ToDictionary(Function(g) g.Key,Function(g) g.ToArray) (10.8 KB)


Thank you for your fast response. It is working.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.