transpose data

  • Thread starter Thread starter KK
  • Start date Start date
K

KK

Hello,

I have a column of data (numbers) which I want to turn by 90 degrees and
make it into a row. I think this is called 'transposing'. ?

I thought there was a transpose option on the data menu, but can't find it.
?

There is a TRANSPOSE function which I've tried, & can't get to work - what
is meant by 'enter the formula into an array' as suggested in help ?

Can anyone point me in the right direction please ?

I have Excel 2000

Thanks

K
 
Hi
I thought there was a transpose option on the data menu, but can't
find it.
Click to expand...
Its on the Paste Special option
Mark your block of vertical data>Copy>move to destination cell>Paste
Special>Transpose
what is meant by 'enter the formula into an array' as suggested in
help ?
Click to expand...
Suppose your source data is in A1:A12 and you want to transpose it to
C1:N1
Highlight your destination range C1:N1
In the formula bar enter
=TRANSPOSE(A1:A12)
and instead of pressing Enter, press Control+Shift+Enter
This will create an array formula, and Excel will place curly braces
{ } around the formula like below.
{=TRANSPOSE(A1:A12)}

Do not type the braces yourself. Use Control+Shift+Enter (CSE) whenever
you edit the formula
 
Thanks - this was very helpful

K


Roger Govier said:
Hi

Its on the Paste Special option
Mark your block of vertical data>Copy>move to destination cell>Paste
Special>Transpose

Suppose your source data is in A1:A12 and you want to transpose it to
C1:N1
Highlight your destination range C1:N1
In the formula bar enter
=TRANSPOSE(A1:A12)
and instead of pressing Enter, press Control+Shift+Enter
This will create an array formula, and Excel will place curly braces
{ } around the formula like below.
{=TRANSPOSE(A1:A12)}

Do not type the braces yourself. Use Control+Shift+Enter (CSE) whenever
you edit the formula
Click to expand...
 
If you don't need to retain the original row format of the data, there is an
easier way to do this. Highlight and copy the cells you want to transpose.
Click in another sheet, or an open area of the current sheet. Click Edit >
Paste Special and select the "Transpose" radio button.
 
Back
Top