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?

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

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?