Selected Answer
I am attaching a spread sheet with 2 solutions: 1. uses formula in Cells C1 & C2 that needs to be copied down (use fill handle & make sure you copy down to an EVEN number of cells that is 2 times your original size (Example if your 2 columns ended at row 12, you would have to copy down to row 24). In cell C1 enter the formula: =INDIRECT("A"&INT(ROW()/2)+1) and in cell C2 enter formula: =INDIRECT("B"&ROW()/2). Then highlight these 2 cells and copy down to double the original range (as described above);
Solution 2: Basically addes 2 helper columns in front of your data in Column A & Column C (see Solution 2 tab); The first column A will be ODD Numbers starting with 1; The other helper column (Column C) will have EVEN numbers 2,4,etc. ~ use Data Fill in increments of 2 to accomplish these! Then copy data to say Column F & G, Put your original 2nd column of data with helper column below the ODD Numbers. Then sort on the new Range.
Best of luck. Please give credit if either of these solved you issue.
Assuming that your data is in Column A & B: Copy (highlight the 2 columns), then move over to say column G (cell G1), then use Paste Transpose. The data now should appear in the 1st & 2nd rows in column G. If it looks good (if it transposed to what you expected....then you can delete columns A& B.