![]() |
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 |
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 |
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