sort every second row

[Guest]

How can you sort by every second row. I would like every second row to go to the colum beside the first row (the row it was under).

 

[Derek]

If your original data is in column A:
use this formula in B1 and scroll down =IF(C1="",A1,""), then
use this formula in C2 and scroll down =IF(C1="",A2,"") make sure C1 is blank
Copy columns B:C and paste special values to convert to values
Derek