Changing Between Orientation of Rows and Columns

J

Jim D.

Is there a way to take a Row of data and turn it into a Column instead ?

My usual way of doing this is to re-type it again.
But I'm starting to get tired of that way (go and figure).
 
D

David Biddulph

Either use the TRANSPOSE function, or copy and then Edit/ Paste Special/
Transpose.
 
L

L. Howard Kittle

Hi Jim,

Try Edit > Paste Special > Transpose > OK.

Copy the column, then select the row you want then do the Paste/Transpose.

HTH
Regards,
Howard
 
K

Kevin Smith

Hello,

if you select the data, right click and copy. Go to where you want the
column information and right click, Paste Special and tick the Transpose
option at the bottom.

This also changes column info into row info if you ever need to do that.
 
Top