View Single Post
  #3  
Old May 28th, 2010, 03:16 PM posted to microsoft.public.excel.newusers
tim m
external usenet poster
 
Posts: 418
Default How do I swap data in columns and rows around?

Copy the data and then 'paste special'....'transpose'

"Monkeroo" wrote:

I've exported a load of data into excel but the info in the columns I want in
rows and vice versa. I'm sure there must be an easy way to flip them.. Can
anyone help?