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
|