transpose

  • Thread starter Thread starter mike allen
  • Start date Start date
M

mike allen

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
 
Hi

Try copying the whole range and then using Paste / Special / Transpose. I
seem to get better results doing it that way.
 
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
 
Back
Top