Thread: Combining Data And Total Values

I need to figure out a way if it is possible to combine similar Invoice numbers into one but totaling the values under each invoice number. For example

09/27/2011 K100112	Moors	Beer	1,304.71
09/27/2011 K100112	Moors       Beer Tax	23.20
09/27/2011 K100112	Moors	Bottle	57.71

I'd like to combine together to show them as

09/27/2011 K100112 Moors        Beer     1385.62

I went through the pivotting table but Im still unsure on how to do it, number one thing is that it uses the old excel. I'm not that great at excel to be honest but know the bare minimum...