Formula that returns all cells with data within a selected range

Hi,

I am trying to find a formula that returns all cells that have data within them as it is a long progress to scroll through and see what data has been entered.

I have attached a workbook with the data.

I basically need a formula that returns all the data without the blank cells in-between. Its so I can easily get a list of which subjects students have been entered for exams.

I hope this makes sense.

I look forward to your help!