Select a blank column (I use column E)

in E1 put 2
in E2 put =IF(MOD(E1,4)=0,E1+2,E1+1)
select E2 and formula copy this to the end of your data
(ie, drag the small block + in the bottom right corner of the selected
E2 downwards)

After the end of your data, find a blank row
in column E of that row put 5
in column E of the next row put =E9999+4 where 9999 is the row you put
the 5
Formula-drag this down far enough so that the number is higher than the
number generated in part 1

Select column E and Copy
Select column E and Paste Special - Values (back over itsself)

select all data (click the block above the 1 in row 1, and left of A in
the column heading)

Sort over column E

Delete column E

Hope this helps


jvoortman Wrote:
is there a quick way to put spaces in data? I have a Excel Spreadsheet
that has data in it which was inported there. There is info in columns
a b c d and in rows 1 through to the end (thousands). I need to get a
space inserted after every 3 lines of data. So it would be A,1-2-3-4
then B, 1-2-3-4 then c, 1-2-3-4 then blank 1,2,3,4, then 3 rows of
info
followed by a blank, and so on. I posted a sample at the address
below:

http://lmr7.homestead.com/index.html

thanks in advance for any help offered!!!!!!!!


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=476385