Re: How Do I reverse axis in a spreadsheet

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm guessing that a 6MB file might have more than a 5R x 20C range.

<vbg>

Cheers!

Biff

"Max" <demechanik@xxxxxxxxx> wrote in message
news:uhF31DahFHA.1252@xxxxxxxxxxxxxxxxxxxxxxx
> If its a one time job, try a copy > paste special > transpose > ok over to
> a
> new ***.
>
> If it's to be dynamic to the source, one way is via using TRANSPOSE()
>
> Assume source range is in Sheet1, in A1:T5 (a 5R x 20C range)
>
> In Sheet2,
>
> Select A1:E20 (a 20R x 5C converse range)
>
> Put in the formula bar: =TRANSPOSE(Sheet1!A1:T5)
> Array-enter the formula by pressing CTRL+SHIFT+ENTER
>
> A1:E20 returns a dynamic transpose of what's in A1:T5 in Sheet1
>
> For a neater look, we could suppress extraneous zeros display via: Tools >
> Options > View tab > Uncheck "Zero values" > OK
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "ChrisH" <ChrisH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:2AE863CD-13DA-421E-B5E4-9ABA3BDF3257@xxxxxxxxxxxxxxxx
>> I have a fairly large (6MB) and mature spread*** that I need to have
>> the
>> columns and rows reversed? (ie. names in the left column and measurements
> in
>> the top row) Is there a global function or is this one large pivot table?
>> --
>> Thank you,
>> Chris H
>
>


.

Quantcast