What function can skip blank cells

I am using offset function to convert tabular data into column as follows;
Table has the form
A B
1
3 4

I am using the offset function of the form
=OFFSET($A$1:$B$2,TRUNC((ROW()-ROW($A$10))/COLUMNS($A$1:$B$2)),MOD(ROW()-ROW($A$10),COLUMNS($A$1:$B$2)),1,1)
whereby from cell A10 down column A i get;
1
0
3
4

But i would like to skip the blank cell B1 which returns 0 and i want the column be as
1
3
4

I will appreceate for any assistance

You could also do: range("b1").entirecolumn.specialcells(xlValues).select
Which selects all cells in column b that contains values.

Function you have is referring Row and Columns locations to find out how many cells offset should take so it is always required that your formula in any cell returns a value (number / text, 0 or "").
A simple VBA routine can solve your problem unless you must use functions.

Thanks Dredwolf,
But my concern was to pick the trend fro cell A11 by 3 then all cells with data down the column A. your formula just eliminates the 0 return
but still the blank effect persists. Mind you iam dealing with a table of hundreds of data with few blanks in between. My point is to have all
data cells with missing to be skipped and the next data be listed in such cell as if there were no missing. I hope you get me well!!