How to add a few blank cells between text filled cells

[GratefullyDyed]

Hello,
I am trying to add 7 blank cells between each data filled cell to properly fit in another spreadsheet for uploading to shopify. Here is what I need in photos:

I need to do that to fit into this:

Please let me know the best way to accomplish this that you know of. Thank you!

 

[kevin9999]

Just as a point of interest, the code "starts" from the bottom - and works its way up to row 1 (or 2) whichever you specify. Thing is - if it works for you the way you've changed it, that's great!

 

[GratefullyDyed]

Just as a point of interest, the code "starts" from the bottom - and works its way up to row 1 (or 2) whichever you specify. Thing is - if it works for you the way you've changed it, that's great!

"Just as a point of interest, the code "starts" from the bottom - and works its way up to row 1 (or 2) whichever you specify"

Oh Thats weird. Figured it was top to bottom..

Ya so far its worked with different amounts of numbers so I think I should be good. Thanks again!