SDCarroll10
New Member
- Joined
- Sep 9, 2019
- Messages
- 5
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
[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