Pull non-blank, text values from array

Hello,

I have a sheet with data in A3:F23, which I named Named_Array1. The data is scattered in the array amongst quite a few blank cells. The data is listed from row 3 until the end of the data without blanks in each column, but below that data the columns are empty. I am looking for a formula which will pull all array data into a single column without blanks.

The closest I've come to getting this to work is:

Please Login or Register  to view this content.

The code above will calculate the first non-blank value correctly, but will not fill down. When I attempt to fill down the second cell repeats the first value and then I receive a

Please Login or Register  to view this content.

in the third cell of the target data column.

I've also tried:

Please Login or Register  to view this content.

&

Please Login or Register  to view this content.

I return a blank cell/error with these two.

Thank you in advance for any advice.

Chris