A colleague has a ss with all possible (20) academic subjects across the top
row and pupils' names down the first column.

Inevitably there are blanks as Sally only does French German and English
whereas Amy does Physics Chemistry and Biology.

How can my colleague remove the blank cells?

I know there's a solution to this, but cannot remember what it is - I had a
disk crash and lost the file with the solution!!! (I now have proper
back-ups...)

Thanks,

Richard