distribute balance on quantity to get unit price by divide two columns after merge data

Hello
first the result should be in sheets MERGE1,2
sheet MERGE1= sheet SELLING , sheet MERGE2=sheet BUYING
so in sheet selling should sum duplicates items based on column C and summing the values for column QTY(G) and TOTAL (I) with ignore column UNIT PRICE because recreate new prices as in sheets MERGE1,2 . after merge data as in sheets MERGE1,2 should divide column TOTAL/QTY to get new Prices and , otherwise data are not repeated based on column C should show normally . I put the slight result. the most important is the duplicate items based on column C .
notice: the data will increase by add or change every time in sheets SELLING,BUYING

I said

otherwise data are not repeated based on column C should show normally

this means will also shows as I put it in result should include it .

You have four thousand rows of data and only a few results shown

I said

the most important is the duplicate items based on column C .

so how many rows should I add to understand me?

Hello.
Let's see if this is what you're looking for?

Please Login or Register  to view this content.

Here is a Power Query Solution for selling. Use the same technique to do the buying.

thanks but I don't any unit price .
and when I attach the file I can't enable the macro gives me message in bar about security , but I have many files on my desktop works well without this problem .

@beyond Excel fantastic! choice vba is much great . just I want keeping the formatting and borders in sheets merge1,2. actually your code deletes , may you fix it, please?
by the way the same problem happened with Alansidman
when I attached the file I can't enable the macro gives me message in bar about security can't enable macro , but I have many files on my desktop works well without this problem . but I copy all of your codes in my file and works.

.
Do you mean this format?

thanks . just last thing can arrange data by sort from small to big based on column B, please?

Originally Posted by Mussa-A

thanks . just last thing can arrange data by sort from small to big based on column B, please?

I think we're done with this, right?

I think we're done with this, right?

really sorry !!
many thanks for youe help