Rotate (NOT transpose) a table 90 degrees

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nataliesykim - 02 Oct 2006 09:16 GMT

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

Reply to this Message

PY & Associates - 02 Oct 2006 09:34 GMT

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

> 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

Reply to this Message

nataliesykim - 02 Oct 2006 09:55 GMT

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

> If the table is n rows by m columns
> To rotate 90 degrees clockwise, try
[quoted text clipped - 9 lines]
> >
> > Nat

Reply to this Message

Pete_UK - 02 Oct 2006 10:06 GMT

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

> Thanks, but is this a macro? If so, how do I type it in? I'm sorry I'm
> not good at this :)
[quoted text clipped - 12 lines]
> > >
> > > Nat

Reply to this Message

Eric - 03 Oct 2006 01:18 GMT

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.

> 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

Reply to this Message

aaron.kempf@gmail.com - 04 Oct 2006 01:59 GMT

Excel isn't a reporting tool.

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

-Aaron

> If the table is a manageable size, you can do it semi-manually, a row at a
> time.
[quoted text clipped - 15 lines]
> >
> > Nat

Reply to this Message