Pivot Table

[Simon]

How would I create a pivot for the following?? and would
it be the most suitable to method to show the results this
for what I want to do.

Right its a worksheet in Excel 2003.

Caller Query
Joe A Complaints
Joe B Complaints
Joe A Complaints
Joe A Shipping
Joe A Refund
Joe B Complaints
Joe A Complaints

Above is what my worksheet looks like. In another
worksheet I need a formula for a cell to count how
complaints/shipping queries each caller takes. So for
example in my results sheet it should show:

Shipping Complaints
Joe A 1 3

I need a formula to do the above??

Any help would be very much appreciated.

Many Thanks in advance.

Simon

..

 

[Paul]

This is now the fifth separate thread you have started on the same question.
If you do this, it's very difficult to follow what has been suggested and
whether or not it has worked. Please keep to one thread, and reply to the
appropriate answer you receive.

For this specific part of your question, why not look up "Pivot Table" in
Help? Do what it says there and then post details if you have a particular
problem.