Excel 2008 : Easier way to sort vertical to Horizontal list...?

Hi all,

I have a set of calculations that colleague did which are arranged vertically like so:

A1-Students
A2-123
A3-Faculty
A4-24
A5-Community
A6-40
A7-Total
A8-147

Of course, I need to have these arranged -

A1-Students B1-123
A2-Faculty B2-24
A3-Community B3-40
A4-Total B4-147

Any thoughts on how to do this easily, without copy and pasting all of the data?

I see this was posted over a month ago, so I don't know if you are still monitoring the thread, but just in case you are, you can put this formula in B1:

=INDEX(A:A,ROW($A1)*2-1)

and this one in C1:

=INDEX(A:A,ROW($A1)*2)

and then copy the formulae down as far as you need to.

Hope this helps.

Pete