Excel 2007 Delete Columns when rows below are blank
I need to be able to cut down on the amount of blank columns I have in a spreadsheet. Each column has a title and below the title there may be some cells which are populated and some which are not. I want to delete any column which has only blank cells beneath the title.
I have attached an example of the spreadsheet. The first five rows will always blank.