Formula to extract only rows with values.(Microsoft Excel)

Includes formulas to retrieve only valid rows and examples of their use.