Excel/Word Table Reorientation...

danza · 17 Apr 2012 at 18:31

I have a fairly hefty table that is 4 columns wide and 39 rows long. Is there a simple way to effectively rotate the table 90° so that I have 39 columns and 4 rows (NOT rotating the text)?

I failed to find a way of doing this last time I tried and instead spent ages copying from one table to the other.

Any help would be spiffing as it means I can procrastinate for a bit longer in the time saved.

Swordfish · 17 Apr 2012 at 18:34

Is this what you are after

http://www.excelforum.com/excel-new-users/570414-how-to-rotate-table-clockwise.html

ChileanLlama · 17 Apr 2012 at 18:36

Try this:

Copy the data
Select the cell you want the data to go to
Paste Special, check Transpose

danza · 17 Apr 2012 at 18:40

YOU WIN!!

I tried this method once before and for some reason it didn't work, so I gave up with it. However, this time it worked, so you can rest knowing that you've helped me to shirk my assignment work for a further hour or so.