How to get Sub Array

[leibale]

from the array {"aa";"ab";"";"ac";""} I want a sub array with all the items that are not "" (only 3 items)
How to do it?

 

[leibale]

Or,
A1: AA
A2: AB
A3:
A4: AC
A5
I want a formula to get an array with the 3 cells with the text

 

[fairwinds]

Hi,

Try this:

Formula must be entered with ctrl + shift + enter in B2, then dragged down.

Book2
	A	B	C	D
1
2	AA	AA
3	AB	AB
4		AC
5	AC
Sheet5

 

[leibale]

it works. thank you. now i'l spend a time to understand it