Transpose and Manipulate Data - Exclude Blank cells

I need some help with the attached Excel spreadsheet that contains a macro which exports data into a fixed width format ready for importing into an ERP system. A member of this forum Mehmetcik wrote the code for me and I have since made some minor amendments but I need some further help with changing it still further.

The Export Macro works but I need help with amending the code as follows;

The user wants to leave blank rows between records when they input the stock codes and quantities (why oh why I hear you all say, and yes that's exactly what I said but without boring you with the details it would be helpful if this is achievable). I understand that the last row may need to be indicated so that the system knows when it has reached the final records so perhaps this could be indicated with a single defined letter or the word END in column A.

Also the end user finds it cumbersome to enter zero values (as there are lots of them) where they dont have a quantity but the current code requires a zero otherwise it exports the stock code together with null value for the quantity which causes an error when importing it into the ERP system. Again if the last column needs to be indicated to tell the system when it has reached the last value then perhaps a single character or word to define the end of the row.

I really hope someone can help me or that 'Mehmetcik' sees this post.

Caz