Sorting data

I have been given the task of recording all the promotional offers made my each employee in my company each week. I download the spreadsheet from the company database and it looks like this (see attached). I have been requested to sort the employees into their teams (assume team 1 has employee: a,b,c and d, and team 2 has employee: e,f,g and h) which also shows the figures for each promotion per employee. I thought of using a pivot table for this (although I don't know how I would sort it into teams), but he thought of manually formatting the spreadsheet for 100+ employees so that a pivot table can be used is daunting.

Is there a quicker way?

Cheers

Update: Just talked to IT, they may be able to get the names running down the side for each promotion code which means this is no longer relevant.