With your data in say A1:A100, in B1 put 1 and then in B2 put =B1+3 and copy
down to B400 (ie 4 times as many rows as you currently have).

Copy Col B and then paste special as values.

Select A1:B400 and sort ascending on Col B.

Delete Col B

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"dhjacha" wrote in message
...
Pleaseeee help me! I have a worksheet with rows from 1 till 1300 and i
need
to add
a 3 rows in between each data row.
I mean if i have
1 Data
2 Data
3 Data
And I want
1 Data
2Blank
3Blank
4Blank
5 Data
6Blank
7Blank
8Blank
9 Data

How do I do, please I really need this and am to looser in excel, how can
i
make this easy way.

Thanks so much