Complicated Excel - Read and Create a new Excel

Help
5

@Lahiru.Fernando How about this Remove Blank Rows, Separate column F separating each model number into its own line