View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi Bondi is offline
external usenet poster
 
Posts: 94
Default how do I move data in prexisting rows to columns?


darryl wrote:
I have ranges of data in rows. I want to arrange the data in columns. How do
I go about it?


Hi Darryl,

Maybe you can use the Transpose option under Paste Special.

Select your data - Edit - Copy.
Then select where you want your data and go to Edit - Paste Special
and tjeckmark Transpose and press OK.

Regards,
Bondi