Dynamically select and delete a range of rows in Excel

For “Table 1” in the attached file in need a code that would dynamically select last row and delete all the blank rows below it except the blank row right above “Table 2”.  

Please see the attached file to get a better idea of what I’m trying to accomplish.  Please see the ‘Before’ and ‘After’ tab.  

The reason why I need something dynamic to accomplish this is that the number of rows in “Table 1” subject to change.
Example-Sheet.xlsx