I'm so sorry for late response. So after I go thru in your file please do me a favor by conclusion overall amount of each supplier by consolidate all brand for me.
Your data almost good but it will be perfect if you can consolidate data base on supplier not item krub.
If you have any question please ask me