adjust Excel macro that parses pasted Input data

Job ID: 34640500

Budget: $10 – $30 USD

We need this existing macro adjusted, so that the 1st line output (see RED in example) becomes the last line of the output.

The macro accepts input into 1 cell (could be from 2 to 25 lines pasted into the "input" cell. Then the lines get parsed into 2 sets of new rows. This works, but we just need to have the 1st line of input show up as the last line in each output set.
Related categories: Visual Basic Excel Visual Basic for Apps