Results 1 to 2 of 2

Thread: How to swap data between columns and rows in Excel

  1. #1
    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.

  2. #2
    Join Date
    Jul 2011
    Posts
    435

    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.

Similar Threads

  1. Replies: 2
    Last Post: 01-02-2012, 06:13 PM
  2. Replies: 3
    Last Post: 31-12-2011, 04:04 PM
  3. Changing rows into columns in excel
    By Gannon in forum Windows Software
    Replies: 5
    Last Post: 25-12-2009, 05:10 PM
  4. Rows and Columns in Excel are Inverted
    By Joachim in forum Windows Software
    Replies: 3
    Last Post: 31-03-2009, 10:16 PM
  5. Replies: 3
    Last Post: 26-02-2009, 01:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •