Rotate (NOT transpose) a table 90 degrees

[nataliesykim]

Hi,

Can anyone please teach me how to ROTATE a table 90 degrees? Transpose
merely switches Rows to Collumns but that's not what I want. Thanks!

Nat

 

[PY & Associates]

If the table is n rows by m columns
To rotate 90 degrees clockwise, try

for i=1 to n
transpose row (i) to column (m+2n-i)
next i

 

[nataliesykim]

Thanks, but is this a macro? If so, how do I type it in? I'm sorry I'm
not good at this

 

[Pete_UK]

Do you mean to rotate the text by 90 degrees? If so, highlight the
table and click Format | Cells | Alignment tab then in the Orientation
box you can drag the red diamond up to 90 degrees and click OK.

Hope this helps.

Pete

 

[Guest]

If the table is a manageable size, you can do it semi-manually, a row at a
time.

Assume that your table is 5 rows by 5 columns (i.e.,range A1:E5), and that
you're rotating counter-clockwise.

1. Highlight the first column (A1:A5). Paste Special with Transpose to the
last row (row 5) of the destination.
2. Highlight the second column (B1:B5). Paste Special with Transpose to the
next-to-last row (row 4) of the destination.

and so on for the rest of the table.

 

[aaron.kempf]

Excel isn't a reporting tool.

it's not as powerful as 'crystal reports' for example

-Aaron