Transposing a Range

[djain]

I am trying to use a named range and transpose it on the same sheet but I am getting a #value error. So, my excel has values in cells E15 to I15 and need them in cells O24 to O28. Also, I have values in cells E37 to I37 that I need in O3 to O7. How can I do that so that if the values change in the former cells they automatically update in the latter?

Thank you so much for your help in advance!

djain

 

[jeffreybrown]

Hello & Welcome to the Board,

Try...

=TRANSPOSE(E15:I15)

IMPORTANT
This is an array formula
Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
If entered correctly, the formula will be enclosed in {brackets}
Do not enter the {brackets} manually

 

[Desu Nota from Columbus]

I am trying to use a named range and transpose it on the same sheet but I am getting a #value error. So, my excel has values in cells E15 to I15 and need them in cells O24 to O28. Also, I have values in cells E37 to I37 that I need in O3 to O7. How can I do that so that if the values change in the former cells they automatically update in the latter?

Thank you so much for your help in advance!

djain

Why not use?:

O24: =E15
O25: =F15
O26: =G15
etc...

O3: =E37
O4: =F37
etc...

 

[djain]

Thanks Jeff, I tried this formula and got the brackets as well after hititing F2>Ctrl+Shift and Enter but this just gave me the first cell value and not the remaining range. When I tried to drag it to the rest of the cells I still did not get it. I am trying to get it right without doing it manually so I can handle a larger range too.

Any advice on this please?
Thanks

 

[jeffreybrown]

Highlight O24:O28 and enter =TRANSPOSE(E15:I15) then hit Ctrl + Shift + Enter

 

[djain]

Thank you so much Jeff, it worked out well.

Cheers,

djain

 

[jeffreybrown]

You're Welcome...Glad it worked out for you