Tidying an Excel Table

[Excel_77]

Hi All,

I have a standard Excel table with heading across row 10 and all corresponding information under this.

My problem however is that I am now required to input information relating to each of the heading above it. At the moment this is looking a little untidy as some columns only have one line to input while others have ten lines and I was wondering if there is a better way to present this information?

Thanks in advance.