+ Reply to Thread
Results 1 to 4 of 4

Flipping Excel Spreadsheet On Axis and Paste Special (Transpose)

  1. #1
    Registered User
    Join Date
    11-10-2009
    Location
    LDN
    MS-Off Ver
    Excel 2003
    Posts
    2

    Flipping Excel Spreadsheet On Axis and Paste Special (Transpose)

    Hi there,

    I have an excel spreadsheet with 43 columns 381 rows, I need to switch these around so that the data in the rows is in columns and vice versa, but keeping the order of the data (its a very complex rota).
    I googled this and found the copy>paste special>transpose function, however i have had some problems with this. Whenever i select paste special>transpose etc, a box pops up telling me the cells are different sizes and therefore cannot be pasted. Some of the cells are empty and some are different colours.
    Does anyone know a solution for this or perhaps a different method of achieving the same thing?

    On a similar line, this is something that will need to be done annually for a few spreadsheets and is quite laborious. I was wondering if anyone may give me some advice on if i can and how to create a program/forumla to do this automatically? I thought it may be possible through VBA.

    I am running Excel 2003 on a windows XP machine (at work so i dont have admin privilidges)

    Many thanks for any help

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Flipping Excel Spreadsheet On Axis and Paste Special (Transpose)

    In Excel 2003, you only have 256 columns.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-10-2009
    Location
    LDN
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Flipping Excel Spreadsheet On Axis and Paste Special (Transpose)

    right thats probably part of the problem, does excel 2007 have more columns? perhaps i can force the boss to upgrade if it does

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Flipping Excel Spreadsheet On Axis and Paste Special (Transpose)

    A few more - 16,384

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1