I have two columns in a spreadsheet "Quantity" and "Item".  I filter
the quantity column to select only the "nonblanks".  After this step I
want to copy these two columns and paste them into a Word document.
Once it's in Word I want to insert a column to the left of the
quantity column and format it with "bullets & numbering" so I can
number the items 1. through whatever.  Problem is, the numbering
behaves as if the blanks are still there so it skips around.

I do not want to delete the blank rows in the original spreadsheet
where the quantity is blank because they may be needed at a later
time.

Any suggestions how I can get these two columns into Word and be able
to number them sequentially?