Fill a simple sequence 1, 2, 3, 4 etc in a blank column next to your
data. Obviously, this will go down to row 24000. Then copy the numbers
in this sequence and paste them directly below, so that you now have
1- 24000 in those rows and 1 - 24000 in rows up to 48000.

Then select all that data down to row 48000 and sort using the helper
column as your sort field. Then you can delete the helper column.

Hope this helps.

Pete

On Nov 30, 10:28*am, Confused from Hertford <Confused from
wrote:
Need to input alternate blank rows into imported spreadsheet. *Currently has
24000 lines of data and would like to find a way of not having to manually
input these blank rows! help! *Also if this is possible will I be able to
format row height at the same time?