View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Kevin Smith[_2_] Kevin Smith[_2_] is offline
external usenet poster
 
Posts: 47
Default Changing Between Orientation of Rows and Columns

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.
--
Kevin Smith :o)


"Jim D." wrote:

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).