I am trying to create a macro that will loop through list of items containing
4 columns and Paste Special Values Transpose into a Single column on a blank
worksheet. My problem is that Col C & D are blanks, so I need to step down 4
rows with each paste.

PartNo-Qty-Blank1-Blank2

I need it to be:

PartNo
Qty
Blank1
Blank2
PartNo
Qty
Blank1
Blank2