Table
-----
FileName EmailAddress
(0,0) File A (1,0) [email protected]
(0,1) File A (1,1) [email protected]
(0,2) File B (1,2) [email protected]
(0,3) File B (1,3) [email protected]
(0,4) File C (1,4) [email protected]
(0,5) File C (1,5) [email protected]

Hi all, the table above shows the example of my database.
I have managed to convert the recordset from access table to 2D array.
My aim to iterate the array, so if the file name is File A, it will retrieve all the email address which belongs to File A.

I've been trying to think of codes, but i'm bad with 2D arrays, can someone guide me or provide me with examples to achieve my desired results?

Many thanks.