Thread: Change column to a row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Change column to a row
CopyPaste SpecialTranspose.

Paste area cannot overlap copy area and you are limited by number of columns
in a row.


Gord Dibben MS Excel MVP

On Sat, 9 Aug 2008 07:59:00 -0700, yar
wrote:

How can I change a column of data to a row of data?

Reply With QuoteReply With Quote