Open Office remove empty rows

How to remove empty rows in an Open Office spreadsheet document.

1. Select all (Ctr+A) in the spreadsheet document
2. Go to last cell (Ctr+Shift+End)
3. From the main menu, navigate to Data>Sort, then select value for ‘Sort by’ and ‘Then by’

Done