I have a table there rows represent time period. Columns represent different locations “kiosks”.
And values represent sales in each kiosk on different times.

Data example:
Data example
In column B I defined categories for which I would like to calculate sums.

I would like to calculate how sum of sales per kiosk in each of these categories.
Adding aimed result:
Aimed result

I tried to make pivot table but it requires to add each of column (kiosk manually) and there are too many columns to add by hand.