making three columns one, while tripling the number of rows used

HI,
I have an issue I need a solution for . I use Excel 2010 and have a 15k row spreadsheet with 3 columns. 1,3,5.
I need to have the following occur
Column 1 stays in same position. Column 3 moves under column 1 in next row while the information in the cell is moved down two rows. The column 5 is then moved into the blank cell in column 1.
So in the example
A1,A3,A5 and B1 will become A1, B1, C1, and D1

Can someone please help me as I have to do this for about 15k rows in a spreadsheet. I do have some scripting experience but measure myself as a beginner in VBA.
Thank you
Tom Collick

here is the upload if What I so badly explained.

You have transposed the first three columns in to rows, but not the second one. Are you going to do the same to every other row, i.e., row 1 transposed, row 2 remains the same, then row 3 transposed?
You said you have 15k rows, but your sample is too small for that size of data, so perhaps you need to increase your sample to see how the data should be formatted.