I'm trying to set up a worksheets to track the spending of two people by
amount and category. Since it's the shared expenses of two people I'm trying
to keep track of who each purchase was made by (so a person 1 total, person 2
total).

QUESTION
Is there a way for an expense that is in a certain category to be transfered
to the next available cell in a column?

BACKGROUND
I set it up by making one sheet for input and one to display the
information. The input having columns for person/category/amount and the
display showing columns for categories and each person's total.

I knew to use Conditional sums to bring anything for person 1 to one total
in a specified cell, likewise for person 2.

*I would like the display page to list EACH purchase in a category not just
a total of all purchases*