I have a table about the schools like this
first.jpg
As you can see the autofiltering is turned on and I would like to get information as shown on the next image after I have selected "Foreign language" Latin.
last.JPG
After I have done a little bit research I found out that the main problem are the blank cells. But is it possible to do anyway as I want ?
Mayble using XML and XSL or somehow another way.

I'm grateful for any kind of solution.
Cheers