Yes those are normally vertical because ...
As many times, later someone would like that scale for 'Chainage' should vary from 1 to 1000
... so far Excel's sheet is as it is and for me scrolling vertical would be more useful than horizontal.
I've seen many of those.
What would be Your 'But ... something' ... how many colors can You see in Type-sheet? ... I can see two colors - black & white.
IN above sheet can weJust to stimulate interest in dynamic array methods …
= COUNTIFS( Table1[From], "<="& period, Table1[To], ">"& period, Table1[Layer No], layer, Table1[Side], LHS )
entered into the top-left cell of the intended solution range will spill to give the entire table without any further filling or copying.
I also noticed some discussion of different coloured strips. That either takes many conditional formats or another trick is to paint the coloured stripes in first and then use conditional formatting to convert the zero value cells back to white.
View attachment 64555