Assuming your table is similar to this:

Date Client# MoveFrom MoveTo
1/1/05 203 TypeA TypeB

In the Pivot table, add MoveFrom to the Row area, MoveTo to the Column
Area, and Client# to the Data area, as Count of Client#

Pivot tables & tracking data wrote:
I track the movement of kids on a massive log. As they move one home (type
varies) and move into another. I would like to be able to track/summarize the
# of kids moving from a certain type of home into another. Problem is, each
of these movements are on a seperate row (record). I am very familiar with
pivot tables & advanced filtering. I would like to use the pivot table, but
I'm not sure how to go about it.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html