List all Matches between two columns

[ssminnow]

I want to list all the names from one column that have a number in the next column. If the name does not have a number skip and repeat until all the names have been checked. I want the list on the same worksheet and on the same columns. I have tried =Index(a1:a5, Match(a11,B1:b5,0)) but I get one answer not all of them. Any ideas?
Example:

A B
1 Joe
2 Frank 100
3 Tom 50
4 Pat
5 Sue 120


Answer I want is this
A B
11 Frank 100
12 Tom 50
13 Sue 120

[Richard Buttrey]

Have you tried a simple autofilter on column B for non blanks and then copying the filtered data and pasting it underneath your table?

[ssminnow]

Not sure what you are saying.

[Tony Valko]

Try this...

Data Range

	A	B
1	Joe
2	Frank	100
3	Tom	50
4	Pat
5	Sue	120
6
7
8	------	------
9
10
11	Frank	100
12	Tom	50
13	Sue	120
14

This array formula** entered in A11:

=IFERROR(INDEX(A:A,SMALL(IF($B$1:$B$5<>"",ROW(B$1:B$5)),ROWS(A$11:A11))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy across to B11 then down until you get a row full of blanks.

[ssminnow]

I guess I should have used the exact cells because when I run yours it works but when I run mine it does not work.
To be exact, the fields are A12: A74 that contain the names and AE12:AE74 that contain the numbers. Does that make a difference?

[ssminnow]

I guess I should have used the exact cells because when I run yours it works but when I run mine it does not work.
To be exact, the fields are A12: A74 that contain the names and AE12:AE74 that contain the numbers. Does that make a difference?

[ssminnow]

After great direction, I figured it out.. Thanks for your help

[Tony Valko]

Good deal. Thanks for the feedback!