Turning a row's contents into a column of entries

[Musawwir Spiegel]

Using Excel 2002 --

Is there a simple way to copy the contents of the cells along a row so
that they will be appear as entries in cells running down a column?
Is it possible to do the reverse as well?

Musawwir Spiegel
[email protected]

 

[Roger Govier]

Hi

Copy>paste Special>Transpose

 

[Musawwir Spiegel]

Thank you so much. You have saved me a lot of time.

Musawwir