Return non-blank Cells from a Range

Hi all,

Is there a non-array way to return only the non-blank cells from a range?
At the moment I use below formula, but it slows down the file considerably

{=INDEX($D$4:$D$50;MATCH(0;COUNTIF($E$2:E3;$D$4:$D$50);0))}