How to turn rows horizontally to form columns?

[Wilhelm]

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.

[scubadiver]

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.

[starguy]

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.

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.

[Wilhelm]

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.