This is the same as a relational join operation. See the following nodes where the problem has recently been discussed:

• Help needed please: Data Manipulation in 2D Array
• Combine files, while parsing info.

In particular, at the end of the last thread there is an outline of how to go about this for a small example problem.