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?