Count Revenue in Row but Splitting Duplicate Values Based on Number of Duplicate Products in Table

[psmi123]

[TABLE="width: 1529"]
<tbody>[TR]
[TD]Level[/TD]
[TD]Name[/TD]
[TD]Industry ID[/TD]
[TD]Company Sector ID[/TD]
[TD]Sector[/TD]
[TD]Applicability ID[/TD]
[TD]Link[/TD]
[TD]Link Name[/TD]
[TD]Solution Name[/TD]
[TD]Prod 1[/TD]
[TD]Prod 1 Rev[/TD]
[TD]Prod 2[/TD]
[TD]Prod 2 Rev[/TD]
[TD]Prod 3[/TD]
[TD]Prod 3 Rev[/TD]
[TD]Prod 4[/TD]
[TD]Prod 4 Rev[/TD]
[TD]Prod 5[/TD]
[TD]Prod 5 Rev[/TD]
[TD]Total Revenue by Row[/TD]
[TD]Revenue Split[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Dairy Farms[/TD]
[TD]43523[/TD]
[TD]D43523[/TD]
[TD]Dairy[/TD]
[TD]D43523Dairy[/TD]
[TD](blank)[/TD]
[TD]01-Dairy[/TD]
[TD]43523:airy[/TD]
[TD]C123[/TD]
[TD]$100[/TD]
[TD]G231[/TD]
[TD]$50[/TD]
[TD]G231[/TD]
[TD]$50[/TD]
[TD]D637[/TD]
[TD]$74[/TD]
[TD]U369[/TD]
[TD]$32[/TD]
[TD]$306[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Dairy Farms[/TD]
[TD]52236[/TD]
[TD]D52236[/TD]
[TD]Dairy[/TD]
[TD]D52236Dairy[/TD]
[TD](blank)[/TD]
[TD]01-Dairy[/TD]
[TD]52236:airy[/TD]
[TD]D637[/TD]
[TD]$74[/TD]
[TD]C123[/TD]
[TD]$100[/TD]
[TD]N628[/TD]
[TD]$73[/TD]
[TD]N628[/TD]
[TD]$73[/TD]
[TD]C123[/TD]
[TD]$100[/TD]
[TD]$420[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Dairy Farms[/TD]
[TD]74245[/TD]
[TD]D74245[/TD]
[TD]Dairy[/TD]
[TD]D74245Dairy[/TD]
[TD](blank)[/TD]
[TD]01-Dairy[/TD]
[TD]74245:airy[/TD]
[TD]U369[/TD]
[TD]$32[/TD]
[TD]D637[/TD]
[TD]$74[/TD]
[TD]C123[/TD]
[TD]$100[/TD]
[TD]C123[/TD]
[TD]$100[/TD]
[TD]G231[/TD]
[TD]$50[/TD]
[TD]$356[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Burger Deluxe[/TD]
[TD]27434[/TD]
[TD]B27434[/TD]
[TD]Burger[/TD]
[TD]B27434Burger[/TD]
[TD](blank)[/TD]
[TD]01-Burger[/TD]
[TD]27434:urger[/TD]
[TD]C123[/TD]
[TD]$100[/TD]
[TD]U369[/TD]
[TD]$32[/TD]
[TD]G231[/TD]
[TD]$50[/TD]
[TD]G325[/TD]
[TD]$26[/TD]
[TD]D637[/TD]
[TD]$74[/TD]
[TD]$282[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


The end row "Revenue Split" is the row I need completed". For example there are 6 occurrences for C123 but the total revenue for C123 is only $100 dollars, meaning the revenue from C123 should be split 6 times. I don't want the revenue being counted more than once, I want to be able to split it based on number in occurrences in the table. Is there a way to do that? FYI Total Revenue by Row is wrong because it is counting the products more than once.