Thread: change rows to columns/columns to rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default change rows to columns/columns to rows
Hi,

Select all your data,
Copy.
Select cell in which you want the top left cell of the transposed data to
appear.
Paste Special.
Tick the Transpose box.
OK.

Regards - Dave
Reply With QuoteReply With Quote