How do I swap data in columns and rows around?
 

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?

How do I swap data in columns and rows around?
 

As long as you have enough columns to support the number of rows you need, you
can select the range, copy it (Edit|Copy).

Then select a destination cell (outside that selected area) and Edit|paste
special|click transpose.

(Edit|copy and edit|paste special are from the xl2003 menubars)

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?

--

Dave Peterson

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?