Formula for Removing "Empty" rows without VBA???

[Danny_G]

Hi.

I would like to ask, if it's possible to remove empty or special row from a column only with formulas, not with VBA?

I have a column like Column A in the attached image, and I would like to remove the "---" rows and keep the other rows in an other column.

Thanks for your help.

 

[Fluff]

Hi & welcome to MrExcel.
In L1 dragged down

=IFERROR(INDEX($A$1:$A$100,AGGREGATE(15,6,(ROW($A$1:$A$100)-ROW($A$1)+1)/($A$1:$A$100<>"---"),ROWS(L$1:L1))),"")

 

[Danny_G]

=IFERROR(INDEX($A$1:$A$100,AGGREGATE(15,6,(ROW($A$1:$A$100)-ROW($A$1)+1)/($A$1:$A$100<>"---"),ROWS(L$1:L1))),"")

THANK YOU VERY MUCH!!!!!!

 

[Fluff]

You're welcome & thanks for the feedback.