transpose data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KK - 20 Oct 2006 12:58 GMT

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

Reply to this Message

Roger Govier - 20 Oct 2006 13:17 GMT

> 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

Signature

Regards

Roger Govier

> Hello,
>
[quoted text clipped - 17 lines]
>
> K

Reply to this Message

KK - 21 Oct 2006 12:17 GMT

Thanks - this was very helpful

K

> Hi
>
[quoted text clipped - 39 lines]
> >
> > K

Reply to this Message

Ann Scharpf - 22 Oct 2006 02:43 GMT

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.

Signature

Ann Scharpf

> Hi
>
[quoted text clipped - 39 lines]
> >
> > K

Reply to this Message