Help with pivot table or other solution

[rawr19911]

So i am trying to make a pivot table that i can create graphs and other reporting off of-- what i need is the first column listed out ( there are more then jus the 2 shown) and the second column to show a number so what i want is it to report like this

the total can be on the right side if needed. reason i wanted to do this is so management can drop the data in and copy and paste the results in a email