data pivoting

Apologies if this is in wrong section.

I need some pivoting help, not necessarily a pivot table though. Columns A-C are what I currently have, and the other columns are what id like it to look like. (in this case, it has employee ids, sales, and what year they did those sales). Any formula suggestions are helpful.