This tutorial would explain how to create a dependent dropdown list in LibreOffice Calc.
This tutorial would show how to use a basic range based data validation in LibreOffice Calc using a drop down list.
This tutorial will explain how to delete blank rows from LibreOffice Calc sheet.