Remove Blank Rows, Separate column F separating each model number into its own line

I have a XAML file which Reads multiple sheets (in a single excel) and creates a new Excel with a combination of all the Sheets. The program works great, but there are 2 problems associated with it:

  1. Remove Blank Rows - I don’t know how to delete these blank records while creating the excel -http://prntscr.com/ndcvo0
  2. Separate column F separating each model number into its own line…
    Some of the Column F (not all) has comma separated values like 300-03865, 300-03866, 55026089
    So I would like to create a separate record for each in the text.xlsx
    Before Example: http://prntscr.com/ndcwoa
    After Example: http://prntscr.com/ndcx61

Here is the source code with the excels:
Upload.zip (20.8 KB)