I need to have a merge that goes

If the vendors name is " TOM" which will be a merge field then I also need
in another column pull all the "material" for that vendor.

Each vendor could have used a diff number of materials