View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jbm Jbm is offline
external usenet poster
 
Posts: 28
Default Copying Data from 1 format to another

northlake,
Highlight all of your cells and copy them. Then, create a new worksheet.
Click in the uppermost leftmost cell in the new worksheet, it should be
empty. On the paste tab (right-hand side of the toolbar) press the dropdown
arrow to get more options, and click Transpose. I can't see your data, but
this should do exactly what you need.
Regards