Inserting a specific number of blank rows between cells - Excel 2007

Hello!

I have a worksheet with four data columns A,B,C,D starting in row 2. I want to add between every row, exactly 11 blank rows. So if we have:

Please Login or Register  to view this content.

the end result should be:

Please Login or Register  to view this content.

Do I necessarily need a macro for this? Or is there another quick and creative way to achieve this result?

Thank you for your time!

Regards,

excelactuary

Use column E as a helper column and fill a simple sequence down to the bottom of your data - in your example it would just be 1, 2, 3, and cell E5 would be the next available cell. Then <copy> the sequence, move the cursor to the next available cell in the column (press END followed by down-arrow, then down-arrow again) and paste the sequence with CTRL-V, then repeat this ten more times. Then highlight all your data including the helper column, and sort the data using column E as the sort field. At the end you can delete column E, leaving you with what you wanted.

Hope this helps.

Pete

Thanks a lot!