I have a content type, "transaction" setup like this:

Name of item | Size (text field) | Payment (text field)

I need a view to display:

Name of item | S | M | L | Total

Item 1 | $1.50 | $0.00 | $0.00 | $1.50
Item 1 | $1.50 | $2.00 | $0.00 | $3.50
Item 1 | $1.50 | $2.00 | $5.00 | $8.50
Item 2 | $0.00 | $2.00 | $5.00 | $7.00
Item 2 | $0.00 | $2.00 | $5.00 | $7.00

Then I need a way for it to merge the payments together per item sold, for instance:

Name of item | S | M | L | Total

Item 1 | $4.50 | $4.00 | $5.00 | $8.50
Item 2 | $0.00 | $4.00 | $10.00 | $14.00

Is there a way to do this?
I haven't found a module out there that will do this.

Views Calc will put a row in the bottom providing a sum of the totals but I need a sum of each row (in the column to the right) and I don't know what module will merge the data... :/

Thanks in advance for the help!
Phil