Results 1 to 11 of 11

Thread: Transpose

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I am having a problem: I am trying to transpose a column of data to a row. The column has >400 items of data. I used to be able to copy the column of data, then place the cursor in the left most cell of the target row and then click on Paste Special/Transpose. However, when I try to do that now, I get an error message that the target area is not the same size, etc. Any ideas?

  2. #2
    Star Lounger
    Join Date
    Jan 2004
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How many columns do your spreadsheet have?

    If less than the number of items, then it will not work.

    Regards

    Kobus
    Regards
    Kobus

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Kobus View Post
    How many columns do your spreadsheet have?

    If less than the number of items, then it will not work.

    Regards

    Kobus

    No, I only have 454 rows of data. I do believe Excel has more columns than that...

  4. #4
    Star Lounger
    Join Date
    Jan 2004
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Which version of Excel are you using?

    Example Excel 2003 only have 256 columns
    Regards
    Kobus

  5. #5
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by jlkirk View Post
    No, I only have 454 rows of data. I do believe Excel has more columns than that...
    Excel 2007 allows up to 16,384 columns, but other than that, you are limited to 256 as Kobus has indicated.

    If you have the 2007 version, check if it's had its options changed to be compatible with earlier versions.

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Gfamily View Post
    Excel 2007 allows up to 16,384 columns, but other than that, you are limited to 256 as Kobus has indicated.

    If you have the 2007 version, check if it's had its options changed to be compatible with earlier versions.
    Thanks. I looked at all of the options, but didn't see anything remotely related.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Is your workbook a .xls file or a .xlsx file?


  8. #8
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I got it to work by highlighting the cells in the column (not the column header). It worked for 598 rows.

    But when I copied the column by clicking on the column header I got the error you mentioned.

  9. #9
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by HansV View Post
    Is your workbook a .xls file or a .xlsx file?
    An .xlsm file

  10. #10
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Quote Originally Posted by jlkirk View Post
    An .xlsm file
    I just did a transpose from Column to Row with over 3000 entries in 2007.
    Are you transposing a single column to a single row?
    Andrew

  11. #11
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I get the came error if the transposed data intersects the copied data. For example, if I copy a list from cells B10:B20, I cannot paste the data if I select any of the cells in the B10:B20 range or any cells in the A10:A20 range since the pasted data would intersect the copied data.

Posting Permissions

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