Hi,

Let's suppose that your data are in A2:A1000 in Sheet 1. Enter the
following formula in A2 of Sheet 2.

=IF(MOD(ROW($A2)-1,4)=0,"",OFFSET(Sheet1!A$2,QUOTIENT(ROW($A2)-1,4)*3+MOD(ROW($A2)-1,4)-1,0))

Drag the formula across as many columns as you have in Sheet 1 (e.g., A2
....D2)
Then select A2:D2 and drag the formula down the rows (as many as you want).
Once the original data are exhausted, the formula would put 0's at the bottom
rows.
Once all the data from Sheet 1 have been transferred to Sheet 2, select the
entire data are, "Edit" -- "Paste Special" -- "Values", to make the data
independent of Sheet 1.

If your first row is not in Row 2 but Row x (e.g., Row 5), modify the
"Sheet1!$A2" in the OFFSET part of the formula accordingly (i.e.,
Sheet1!$A5). If the first row where you start your your formatted data (in
Sheet 2) is not Row 2 but Row y (e.g., Row 6), change the "ROW($A2)-1" parts
of the formula (there are three of them) to "ROW($A6)-5".

Regards,
B. R. Ramachandran

"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!!!!!!!!