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.