help me organise this excel report generated by our POS. i want it to be SQL-compatible

Hello we are a chain of 9 restaurants. We use "maitreD" as our main Point Of Sale System. the CEO would like to have a report of all the discounts that occured monthly, for each venue. I would like to organize the repport in a fashion that i would be able to feed it in a pivot table. So it has to be kinda SQL-compatible. i need a macro that would reorganize the data. here attached is the file : "[login to view URL]" it's the report file from our POS. as you can see, it's a piece of nonsense. different data appears on the same column, lots a merged cells, footers and headers everywhere... it's not workable. the tab "expected result" is an exemple of what I would like important : in B7 you can see the number associated to the venue (called a "succursale"). this number as to appear on each line. the number can change. if i extract the data for several venues at the same time, the number would increment at some point downwards (it's not at the same row each time) this data is always a number only. column I is the bill number (numero facture) for each bill number, there are items associated that appears bellow, as well as the price of each item "Centre de Revenu" says if the bill has been punched as take out or not, it can be "emporter", "juliette" or "golo". we exepct to have more with uber eats, foodora, etc "montant" (amount) is a difficult beast. it's the actual money discounted on the bill. we can't repeat it more than one time per bill ! I would like to delete all lines where the price of the item is 0 then i would like to distribute the amount of the discount to the items, proportionnaly to their price. exemple : order #563709 has those items (SIM) ESPRESSO LONG 2,85 SHOOTER CHOCOLAT 4,95 total : 7,8$ the total discount on the bill is 0.78$ i want this total to be distributed so the column "montant" would show : (SIM) ESPRESSO LONG 2,85 0,285 SHOOTER CHOCOLAT 4,95 0,495