I will have an inventory of any number of rooms, any of which will have up to 30 different "widgets" (so up to 30 rows, all starting with the 3-digit room number), with different prices.
What I need to do is get a widget summary with total widget sum (easy to do), and either a summary or a concatenation of rooms and quantities of those widgets.
Does this help any?