Is it possible to turn a range of cells into an array using a formula?

Hopefully this will make sense. I have a table where some intersections between rows and columns will have a value, and some won't.    For example   Name English Maths Physics History Eco...