Evaluate text field value and create a column based on unique occurrences

Go to 'Transform Data'

Select the table with all of your data and then select 'Merge Queries'

Select the mapping table and then select the 'EquipmentId' column for both tables...
After clicking 'OK' you will have a new column added to your table that has a table in each row. 

Expand that column. Select only the Department and deselect the 'Use original column name...'

After clicking OK you should have the desired result in your table...