I have a table in cel B2:E26 with Supplier, OrderID, Item, and Quantity. I want to sum the Quantity per Supplier per OrderID per Item in a spilled range. I want the spilled range to show Supplier and OrderID only once (on the first instance), and show blank cells in the next rows, until the Supplier and/or Order ID changes.

I have been trying to find a solution using V.STACK and LET functions, but i can not get it right.