I need to pull specific data based on multiple criteria

I have raw data that lists employees for each tender type. I would like to consolidate the information for just some of the tender types, such as cash and service charges, to make a variance tracking sheet. In the attached sample, my data is on the left, in yellow, and where I would like to see it is on the right. I've highlighted in blue the columns that need to pull data from the left. Any help would be greatly appreciated.