Pull from one column and insert into new w/ spaces

[swiftrain]

I am trying to take Column A and move all values in that column to column E.

1. Move Column A values only IF the corresponding cell in Column B is greater than -0- and

2. keeping the spaces between the different product types.

Disregard the border and fill format on the attached spreadsheet.

*I can pull the information into column E but cannot get the spaces between the different product types or it leaves spaces where there was a -0- in column B.

test pull.xlsx

I hope this makes sense.

[FDibbins]

not sure I understand what you want/how you want it, but have you tried playing around with pivot tables?

[swiftrain]

I have looked at Pivot tables but the formatting doesn't seem to workout with what I can do.

Basically, all I want is to move all information from Columns A & B to E & F as long as Column B is >0. Plus, I need the spaces between product lines placed automatically in the new columns. i.e.:
ColA ColB --------------> ColE ColF

Product Line Qty --------------> ProductLine Qty
ProductLine1 1 --------------> ProductLine1 1
ProductLine1 0 --------------> (SPACE)
(SPACE) --------------> ProductLine2 4
ProductLine2 4 --------------> ProductLine2 2
ProductLine2 0 --------------> (SPACE)
ProductLine2 2 --------------> ProductLine3 89
(SPACE)
ProductLine3 89
ProductLine3 0

How that clarifies it.