Create PO number List skip blank cells

[SDCarroll10]

Existing data is Sheet4!E2:Sheet4!E700 and appears as below:

[TABLE="width: 99"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Retailers PO[/TD]
[/TR]
[TR]
[TD="align: right"]9608561996[/TD]
[/TR]
[TR]
[TD]blank
blank[/TD]
[/TR]
[TR]
[TD]blank[/TD]
[/TR]
[TR]
[TD]blank[/TD]
[/TR]
[TR]
[TD="align: right"]5008561749[/TD]
[/TR]
[TR]
[TD]blank[/TD]
[/TR]
[TR]
[TD]blank[/TD]
[/TR]
[TR]
[TD]blank[/TD]
[/TR]
[TR]
[TD="align: right"]4908561680[/TD]
[/TR]
</tbody>[/TABLE]

I need to pull it to another sheet (column A) but skip the blank rows.

I have tried several Iferror formulas from different threads that are only showing zeros for every result.

Please help

 

[Toadstool]

You're welcome!