Assume source data within A1:A1000
Fill B1:B1000 with the number series: 1, 2, 3, ... 1000
Copy B1:B1000, paste into B1001:B2000
Then just select cols A and B, sort by col B Ascending
Col A is now transformed as desired. Delete col B to clean up.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Critzy" wrote:
I am working with a spreadsheet that has 1000 rows of data. I want to insert
a blank row in between each row of data. Is there a way to do this without
manually right clicking and inserting a row after each one?
Please help!