Sorting sections within large table

[Javid]

I'm really ashamed of the hard work you put in
Well, my friend, I saw your attachment and realized the many problems you mentioned. I was thinking of such a basic surgery, but in the following order:
1. For cells merged in column "A" in the main sheet, deleting the entire column and use the same column in the new datasheet instead, (this can probably be expected from PowerQuery or Column can be added manually to the new sheet if needed ) but without merging any of the cells, this means that instead of duplicate numbers, we will have new and different numbers at the beginning of each rows. (Maximum 2, because in the new table we will have only the lowest prices, in which case we will probably not have more than two identical prices).
2. To solve the problem of merging column header cells, "converting merged column headers to non-merged ones and adding whatever is needed with single cells containing new text for each one" might increase the number of table columns I suggest, but It is worth avoiding this challenge.
3. You also mentioned that it is better to avoid having any formulas in the main sheet.
I agree, and if I'm not mistaken, we can create the same columns in the new sheet instead of some of the columns in the main table that have the formula.
With this changes in the main sheet, the user will enter only specialized information of goods such as name, seller name, code, type, weight of each package, unit price, tax and any kind of information except calculations and the final result of the calculations will be visible and available only in the new sheet.
If you agree with all three of my suggestions, I can apply all three changes to a new file and send it back to you by next week.
Just please tell me if by making these changes we can solve the power query problem as well as creating a new sheet or there are still other problems blocking and if other changes are needed tell me to do them.
Thank you so much for your consultation again and sorry for bothering you.
have a good and nice weekend.