Need help with a simple problem in word/excel...

[clicknext]

I have a giant table of names, about 3 columns wide and 400 rows long, each cell with a name in it. How can I insert an extra empty row after each row of names? I want it to be like this:

|Name
|empty row
|Name
|empty row

Thanks... must learn to use word efficiently...

 

[petesamprs]

Easiest way in excel (requires no coding):

insert a column (new column A). In that column number all odd numbers all the way down the column. ie, the column should read 1,3,5,7... all the way from row 1 to row 400 until you reach the end of your data.

Then, at the bottow of your data (row 401), in column A, start numbering even numbers all the way down (2,4,6,8...enough so you go higher than the highest odd number).

Then highlight all of your data (all 4 columns, and all rows including the even #s), and sort by column A.

A blank row will appear in between each of your rows. You can then delete column A.

(By the way, please don't hand-enter each of the numbers in column A, use formulas like A1=1, A2=A1+2, A2+2, etc. and copy down)