How to move a vertical range of cells into a horizontal range of cells?
In Excel, how can I change a vertical range of cells into a horizontal range of cells
i.e how can I transpose ranges in Excel.
We have a series of names in Cell range A3:A8 and I need Excel to dynamically
move them to the horizontal range C2:H2
We can achieve this by using Excel Transpose Function.
The TRANSPOSE function changes a vertical range as a horizontal range, or vice
versa. It is important to remember that this is an array type formula, so the range
must be of equal size and must be entered with Ctrl+Shift+Enter (a CSE
FUNCTION)
In our example above ,in cell C2 type in
=TRANSPOSE($A$3:$A$8)
Copy this formula across to cell H2. Finally press F2 Function key(edit key)
and press Ctrl+Shift+Enter