transpose data

[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

 

[Roger Govier]

Hi

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

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 ?

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

 

[KK]

Thanks - this was very helpful

K

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

 

[Guest]

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.