This type of structure doesn't lend itself very well to answer questions like 'how many times was kladder seen across all branches?'.
Have you considered using the pivot function? Pivot Data from Columns to Rows
It works fine although I have to make separate workbooks because the pivot function eliminates the