an Excel question

[Tom]

HI, I have a sheet like this:


Tom A 5
Tom A 5
Tom B 5
Jim A 5
Jim B 5

Can you show me how to make it to :

Tom A 10
Tom B 5
Jim A 5
Jim B 5

Thank you

[Gary''s Student]

Yes.

Use a Pivot table. Your highlight the columns you want to analyze and
pull-down Data >Pivot Table and use the wizard
--
Gary''s Student


"Tom" wrote:

> HI, I have a sheet like this:
>
>
> Tom A 5
> Tom A 5
> Tom B 5
> Jim A 5
> Jim B 5
>
> Can you show me how to make it to :
>
> Tom A 10
> Tom B 5
> Jim A 5
> Jim B 5
>
> Thank you