Excel - inserting lines 1

[Santee]

How can I take rows of data and insert two lines between them. See example below:

Looks like this:

A B
1 234 at
2 342 be
3 125 ant
4 782 deal
5 572 field

Needs to look like this:

A B
1 234 at
2
3
4 342 be
5
6
7 125 ant
8
9
10 782 deal
11
12
13 572 field

There are several hundred lines and I need to get two lines between them. Can anyone give me a quick way of doing this?

Thanks!

 

[Zathras]

Assuming you don't want to use VBA, one way is to put these formulae in column C:
[tt]
C1: 1
C2: =C1+3
[/tt]
Then copy the formula in C2 down the column (double-click the little black square in the lower-right hand corner)

Then put this formula in the next available row in column C:
[tt]
C501: =C1+1
[/tt]
{If you have 500 rows of data for example.)
Then copy that formula down for two times the number of rows of data you have. (E.g., If you have 500 rows of data, copy the formula from row 501 through row 1500.)

Finally, copy and paste-special-values the contents of column C on it self and sort on column C.

When finished, delete or clear column C.

 

[Santee]

Thanks so much for you help. It worked.

 

[ylustrata]

Brilliant! Zathras, I gave you a star.

 

[SkipVought]

Hi,

Is there a reason for inserting 2 rows between each row of data?

Skip,
[sub]
[red][/red]
[/sub]