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

Help Activities
, ,
1

Capture
Capture308×540 6.91 KB
from this one
Capture 2
Capture 2870×520 7.04 KB
to this one

2

@jovarie.inoc
Could you please elaborate on your requirement?

3

Hi,

If your input is as the following,

image

Is the result the following right?

image

If so, the following will work.

image
image1075×1553 39.1 KB 

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

Ssample20221216-3.zip (10.8 KB)

Regards,

4

Thank you for your fast response. It is working.

5

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