transpose

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mike allen - 15 Jun 2004 14:44 GMT

for some reason, i cannot get this done. i have done it before but need
help. i have numbers running down columnA and letters running across row1.
i then have formulas filling in the matrix. the total area is A1:L13. i
would like to transpose it where the letters run down and numbers across,
preferably on top of where it is now, but can have it elsewhere. i am even
stuck on the help's simple example of =transpose(a1:c1). it keeps coming
back #VALUE!, even when i highlight 3 cells in a column. any thoughts?
thanks, mike allen

Reply to this Message

Andy B - 15 Jun 2004 14:48 GMT

Hi

Try copying the whole range and then using Paste / Special / Transpose. I
seem to get better results doing it that way.

Signature

Andy.

> for some reason, i cannot get this done. i have done it before but need
> help. i have numbers running down columnA and letters running across row1.
[quoted text clipped - 4 lines]
> back #VALUE!, even when i highlight 3 cells in a column. any thoughts?
> thanks, mike allen

Reply to this Message

Max - 15 Jun 2004 18:12 GMT

Your source range is A1:L13 (a 13R x 12C grid)

Try this to use TRANSPOSE() ..

Select say, A20:M31
(the selected area must be a 12R x 13C grid - the "converse" grid)

Put in the formula bar: =TRANSPOSE(A1:L13)

Array-enter the formula
(press CTRL+SHIFT+ENTER, instead of just ENTER)

Excel will wrap curly braces { } around the formula, viz.:
{=TRANSPOSE(A1:L13)}

and the same formula will appear in each cell in A20:M31

In A20:M31 will the transpose you want
which is linked to the source range in A1:L13
--
For a neater look, consider suppressing zeros from showing via:
Tools > Options > View tab > Uncheck "Zero values" > OK
--
The error which you mentioned in the post was probably
because you did not array-enter the formula (CTRL+SHIFT+ENTER)

Signature

--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
---

Reply to this Message