Alternative to Vlookup

Hello

I am working on a spreadsheet, and need to convert a list of suppliers materials on different rows, so they are displayed in columns, if this makes sense

- I have attached a spreadsheet showing the issue.

I need to get the "Overview" sheet to list the materials each supplier supplies in horizontal order, I have done V lookups on the first two sheets, so the material supplied is on the "supplier and codes" tab and the supplier is on the "Codes and Materials" tab.

The reason behind doing this is so that I can send out an email (as a mail merge) and the supplier will recieve one email with a list of materials rather than several emails, one for each material.

Hope someone can help me... it would literally save me DAYS!!!!

Here,try this: