View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default Trivial question

If you just want to do it as a one-off then you can <copy the values,
move to cell L1 then Edit | Paste Special | Values (check) and
Transpose (check) then OK and <Esc.

You can also use the TRANSPOSE( ) function - details in Excel Help.

Hope this helps.

Pete