How do I swap data in columns and rows around?

M

Monkeroo

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?
 
D

Dave Peterson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

flip rows with columns 2
Reverse a spreadsheet reversing columns and rows? 3
VBA - retrieve data on last create named range from previous inserted named range 0
changing columns into rows 2
Switching rows and columns 3
PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
How do number columns first, then the rows in an excel footer? 1
how do I shred repeating fields in an excel table? 1

Top