Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to swap data between columns and rows in Excel

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 08-01-2012
Member
 
Join Date: Dec 2011
Posts: 40
How to swap data between columns and rows in Excel

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? Any of the suggestion will be thanks.

Reply With Quote
  #2  
Old 08-01-2012
Member
 
Join Date: Jul 2011
Posts: 431
Re: How to swap data between columns and rows in Excel

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 Excel. This is the smile way for swapping data.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to swap data between columns and rows in Excel"
Thread Thread Starter Forum Replies Last Post
Does by reducing the blank rows and columns will reduce Excel file size Wisaal MS Office Support 2 01-02-2012 06:13 PM
Getting Error " Print titles must be contiguous and complete rows or columns" on Excel LynchL Windows Software 3 31-12-2011 04:04 PM
Changing rows into columns in excel Gannon Windows Software 5 25-12-2009 05:10 PM
Rows and Columns in Excel are Inverted Joachim Windows Software 3 31-03-2009 10:16 PM
Excel 2003 - require assistance importing rows instead of columns Zeeman28a Windows Software 3 26-02-2009 01:51 PM


All times are GMT +5.5. The time now is 08:51 AM.