bring row data to a coulm based on a Reference Bill no. and party

HI


I sincerely thank this forum for helping me at various stages
I need a help now
We are using this format for sales tax return filing purpose.

The raw data is available original data. It is listed as per item billed in the respective bill no.
Some times a bill may contain one item some time more than 20 items.
Freight transport charges are also billed.
As a purchaser of commodity we need to club transport charges to take respective row of the item and show add to cost of purchase.
We use combining bn and supplier to arrive unique ref no and do vlookup countifs for bringing transport
charges. Against one of the bill reference.
In case two transport charges are billed for the same bno. It needs to be totaled and bring as total freight against a particular reference no
Some times this list may be exhaustive during peak completion of a project 2000 to 3000 records a month

is it possible to automate through coding
This may be use ful especially if i am handing over this job oridinary user.
A excel file is attached
Thanks in advance for your help.
N.Srinivasan