Insert x number of rows

[BakerBaker]

Good morning, thanks in anticipation.

Column A consists of a variable number of rows containing data, with each "block" of rows being separated by a blank row. I would like to be able to insert X number of rows after each existing blank row so that each new "block" of rows totals 13. In the example below "JAN" is row 1 - row 14 - row 27 - row 40 etc

Col. A

• 1 JAN
• 2 FEB
• 3 MAR
• 4 APR
• 5 (blank) Insert 8 blank rows
• 14 JAN
• 15 FEB
• 16 MAR
• 17 APR
• 18 MAY
• 19 JUN
• 20 (blank) Insert 6 blank rows
• 27 JAN
• 28 FEB
• 29 MAR
• 30 APR
• 31 MAY
• 32 JUN
• 33 JUL
• 34 AUG
• 35 (blank) Insert 4 blank rows
• 40 JAN
• 41 FEB -etc.

 

[rollis13]

@Joe4, I followed OP's indication:

I would like to be able to insert X number of rows after each existing blank row so that each new "block" of rows totals 13.

 

[Joe4]

@Joe4, I followed OP's indication:

Well, that clearly proves that you are a better reader than I am!
So it definitely looks like your interpretation is the right one.

Unfortunately, sometimes I focus too much on the images (I like visuals) and not enough on the words!