May I pose a question regarding deleting blank ( unwanted) rows and columns in the same cell range.
Assuming a corporate group has 10 separate and individual companies (Company A – J). And there is 8 different types of Fee (Fees 1 – 8) being charged among the companies. As a group policy, respective company must use the standard template that is designed to covers all the 10 companies and 8 types of Fee.
However, not all the companies will charged (or be charged with) all or same type of fee, and therefore many cells are empty as shown in the light green shaded table in the file attached.
I am using in particular, Company A as an illustrative example in the attached file ( in matrix presentation), Company A ( the charging Co) only charge Fee 1, 3, 4,5,8 to Company B,E,G,H & I.
This has caused the necessity to delete the blank rows and columns so as to generate the final presentation as shown in the light orange colour shaded table.
It seems this can not be done by using “Find & Select”, “Goto Special”, “Blank”,”Delete Sheet Rows/Columns” functions.
May you please advise on this.
Thanks and cheers.