Blank Rows

[miroj1]

Hello again Excel masters.
I have a 1000 row list and I want to put a blank row in between every filled row. Is there a quick way to do this?
Thanks for your help.

 

[Mark W.]

Number your rows sequentially as I did in the blue bordered range below. Duplicate those numbers (red bordered range) direcly below the 1st set of numbers.

Book1
	A	B	C	D	E
1	filled	filled	filled	filled	1
2	filled	filled	filled	filled	2
3	filled	filled	filled	filled	3
4	filled	filled	filled	filled	4
5	filled	filled	filled	filled	5
6	filled	filled	filled	filled	6
7	filled	filled	filled	filled	7
8	filled	filled	filled	filled	8
9					1
10					2
11					3
12					4
13					5
14					6
15					7
16					8
Sheet1

Sort on the column containing those numbers (column E) to get...

Book1
	A	B	C	D	E
1	filled	filled	filled	filled	1
2					1
3	filled	filled	filled	filled	2
4					2
5	filled	filled	filled	filled	3
6					3
7	filled	filled	filled	filled	4
8					4
9	filled	filled	filled	filled	5
10					5
11	filled	filled	filled	filled	6
12					6
13	filled	filled	filled	filled	7
14					7
15	filled	filled	filled	filled	8
16					8
Sheet1

This message was edited by Mark W. on 2002-09-04 16:15

 

[Juan Pablo González]

Either J-Walks' PUP 5 or ASAP Utilities have this feature in them

PUP is available at http://www.j-walk.com/ss

ASAP Utilities is at http://www.asap-utilities.com

 

[zacemmel]

=IF(ISODD(ROW(A1)),INDIRECT("A"&ROUNDUP(ROW(A1)/2,0)),"")

Use that formula assuming you have the analysis toolpak installed and your data is in column A.

 

[miroj1]

Thanks for the help Mark W. . It worked like a charm.
miroj1