How to turn rows horizontally to form columns?
 

Is it possible to transfer text from cells in a row so that they form a
single column. In other words is it possible to turn a row 90 degrees so that
the cells which were beside each other now are underneath each other.

How to turn rows horizontally to form columns?
 

Is it transposition you are referring to?

Highlight the cells, copy and go to paste special. The tranposition check
box is in the bottom right hand corner.

"Wilhelm" wrote:

Is it possible to transfer text from cells in a row so that they form a
single column. In other words is it possible to turn a row 90 degrees so that
the cells which were beside each other now are underneath each other.

How to turn rows horizontally to form columns?
 

select the cells of that row suppose A1:G10, copy this range, right
click on A2
click paste special and at the end check the transpose option then
press ok.
you are done.

Wilhelm Wrote:
Is it possible to transfer text from cells in a row so that they form a
single column. In other words is it possible to turn a row 90 degrees
so that
the cells which were beside each other now are underneath each other.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=558122

How to turn rows horizontally to form columns?
 

Thank you,
That was exactly what I meant.



"scubadiver" kirjoitti:

Is it transposition you are referring to?

Highlight the cells, copy and go to paste special. The tranposition check
box is in the bottom right hand corner.

"Wilhelm" wrote:

Is it possible to transfer text from cells in a row so that they form a
single column. In other words is it possible to turn a row 90 degrees so that
the cells which were beside each other now are underneath each other.