ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help me understand Transpose (https://www.excelbanter.com/excel-worksheet-functions/133108-help-me-understand-transpose.html)

S Davis

Help me understand Transpose
 
Hello all,

I don't seem to understand Transpose.

I have a set of data 10 columns in length, cells A1 - J1. All I want
to do is have a formula take this line and transpose it downwards.

I have tried:

=transpose($A$1:$J$1)
=transpose(A1:J1)
{=transpose($A$1:$J$1)}

.....

It simply will not transpose my data. Do I have this set up correctly?
Do I need my data on the right side of my formula?

I should note that copy - past special - transpose works fine, but
this needs to be automated.

Thanks
-SD


Toppers

Help me understand Transpose
 
See replies to your previous posting on this subject.

"S Davis" wrote:

Hello all,

I don't seem to understand Transpose.

I have a set of data 10 columns in length, cells A1 - J1. All I want
to do is have a formula take this line and transpose it downwards.

I have tried:

=transpose($A$1:$J$1)
=transpose(A1:J1)
{=transpose($A$1:$J$1)}

.....

It simply will not transpose my data. Do I have this set up correctly?
Do I need my data on the right side of my formula?

I should note that copy - past special - transpose works fine, but
this needs to be automated.

Thanks
-SD



Teethless mama

Help me understand Transpose
 
Select blank cells A3:A12
=TRANSPOSE(A1:J1)
ctrl+shift+enter

or

=INDEX($A$1:$J$1,ROWS($1:1))


"S Davis" wrote:

Hello all,

I don't seem to understand Transpose.

I have a set of data 10 columns in length, cells A1 - J1. All I want
to do is have a formula take this line and transpose it downwards.

I have tried:

=transpose($A$1:$J$1)
=transpose(A1:J1)
{=transpose($A$1:$J$1)}

.....

It simply will not transpose my data. Do I have this set up correctly?
Do I need my data on the right side of my formula?

I should note that copy - past special - transpose works fine, but
this needs to be automated.

Thanks
-SD




All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com