That does not seem to make any sense to me. You should not be losing any rows.
Can you create a small example where this is happening, and post images of your "before" and "after" data.
You can post images using the tools mentioned here: XL2BB - Excel Range to BBCode
I think I figured out why it was happening to me. When I created "test" rows, I did have anything in Column A. I just tested it again with a value in A and it worked. Woohoo! I'm so excited. Thank you Joe!!