Create PO number List skip blank cells

[SDCarroll10]

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

Retailers PO

9608561996

blank blank

blank

blank

5008561749

blank

blank

blank

4908561680

<colgroup><col></colgroup><tbody>
</tbody>

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!