How do I swap data in columns and rows around?

  • Thread starter Thread starter Monkeroo
  • Start date Start date
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?
 
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

Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
flip rows with columns 2
Reverse a spreadsheet reversing columns and rows? 3
Reformat Row to Column 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
Switching rows and columns 3

Back
Top