Can anyone help me create a pivot table for the following setup?


Here's a company's usage of certain supplies sorted by department.
usage.png

Here's the supplies we have on file.
rawdata.png

Is there any way I can pivot these so that I get the internal code displayed instead of the supplier, as follows?
INT.png