Are you able to change the header of this spreadsheet? Can you make the header into a single row and have:
If you can do this then the Crosstable() function plus a little jiggery-pokery will achieve what you want.
You need some transformation:
During the Wizard to load the table, enable transformation step, rotate the type -> Transpose, then use fill on the first column.
Then you use cross table.
After this, I believe you would be able to use the data but to make exactly in your format I used load resident and an outer join.
I just had to adjust the cell F1 of your example, because there was a second value there 'Ascot'. I don't know why.
Hope this helps,