insert blank cells

I

iturnrocks

I have a column of hundreds of part numbers. I want to insert a new row
between each one. Is there a way to insert rows between all of them at
once?

From this
____A___B___C___D
1__432
2__527
3__640
4__243

To this
____A___B___C___D
1__432
2
3__527
4
5__640
6
7__243
 
M

Max

One way ..
Assuming source data in A1:A10
Fill-in the series: 1,2,3, ... 10 into B1:B10
Copy the series in B1:B10, paste into B11:B20
Then select cols A and B, sort by col B > ascending
Clean up by deleting col B
 
S

shail

Nice trick Max!!

Thanks

Shail
One way ..
Assuming source data in A1:A10
Fill-in the series: 1,2,3, ... 10 into B1:B10
Copy the series in B1:B10, paste into B11:B20
Then select cols A and B, sort by col B > ascending
Clean up by deleting col B
Click to expand...
 
I

iturnrocks

Max said:
One way ..
Assuming source data in A1:A10
Fill-in the series: 1,2,3, ... 10 into B1:B10
Copy the series in B1:B10, paste into B11:B20
Then select cols A and B, sort by col B > ascending
Clean up by deleting col B
Click to expand...

Thanks, that works great
 
Top