0
Similar to this question, I want to display the values of a named range (horizontal) in a vertical range.
If I have data a b d f which is named Letters (as a named range). I want to display this named range transposed (i.e. proceeding downward with the V's), how do I do this?
+-+-+-+-+-+-+-+
|a|b|d|f| | | |
+-+-+-+-+-+-+-+
| | | | | | | |
+-+-+-+-+-+-+-+
|V| | | | | | |
+-+-+-+-+-+-+-+
|V| | | | | | |
+-+-+-+-+-+-+-+
|V| | | | | | |
+-+-+-+-+-+-+-+
|V| | | | | | |
+-+-+-+-+-+-+-+
I've tried the Ctrl+Shift+Enter answer suggested by @Excellll in the referenced question, but when the fill handle is dragged downwards, only the a value propagates downward. If the TRANSPOSE() function is the answer, nothing I've tried with it has worked yet ({=TRANSPOSE(Letters)} for example
user3.1415927
Posted 2015-08-05T19:34:39.723
Reputation: 296
1What is
{=TRANSPOSE(Letters)}returning? It works for me in my tests. Make sure you are selecting the entire output range before entering the formula. – Excellll – 2015-08-05T19:40:25.740Strange; it didn't work before, the output was all
a a a a, but it's working now. Thank you. I will update the original question if that is the proper documentation procedure... – user3.1415927 – 2015-08-05T20:04:04.553