Return multiple string values

Dear excel pros!

I have a table with multiple strings in one column (there are also several cells withOUT any strings). The table looks like this:

	A
1	Name
2	John
3	Name
4
5	Alex

Table 1

Note: The real table is much longer than this. Otherwise this would be fairly easy..

Now, what I want to do, is to copy all of the strings from column A (in Table 1) to a new table (Table 2). However, I don't want to copy the empty cells nor the cells with the "Name" string. The result should look like this:

	A
1	John
2	Alex
3

Table 2

I appreciate all the help you can provide!

My thoughts:
I think that the formula in f.x cell "A1" in "Table 2" (the result table), must start searching in "Table 1" for any strings except "Name". If the formula finds any string/text, it must return the value to cell A1. The formula in "A2" must then start its search from the cell that contained text (the result from cell A1).

Wow, Thank you! But I get Alex two times, and no John. If I change the formula from "SMALL" to "LARGE" I get John two times, and no Alex. Like this:

	A
1	Alex
2	Alex
3

If I remove the argument "SMALL/LARGE", I get nothing..

Thank you so much! Now it works perfectly!