Formula required

[Kelly290]

Can anyone help me with a formula please?

I need to find all blank cells within a column and delete all the rows containing the blank cells.

Thankyou

[#2]

@Kelly290 

You don't do that with a formula.

Select the column by clicking on its column header.

Press F5 or Ctrl+G to activate the Go To dialog.

Click Special...

Select Blanks, then click OK.

On the Home tab of the ribbon, in the Cells group, click Delete > Delete Sheet Rows.

[#3]

Hello,

You can check out how to identity and delete all blank rows in Excel and Power Query in the link below

https://www.exceljetconsult.com.ng/home/blog/delete-blank-rows-in-power-bi-and-excel/