Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Paste Special-Transpose (2000)

    I have an Excel table of 12 columns (Months) by 30 rows (Years) of historical data. I would like to transpose the 30 rows into one long column of historical beginning with the first month of data (in cell A!) and continuing downward. Anyone have any tips?
    Thanks,
    Jeff

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Paste Special-Transpose (2000)

    With only 12x30, I would just reduce the view zoom to 50% and drag 'n drop. --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Paste Special-Transpose (2000)

    Do you mean cut and paste? If not, I don't know what you are saying...

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Paste Special-Transpose (2000)

    Sorry, if you select the 12 cells, then if you move your cursor to the borderline, your cursor changes from a plus to a pointer shape and you can press the mouse key and drag and drop the region anywhere. By default, the cells are moved as if you did a cut & paste, but if you use the right-mouse-key to do the drag and drop, you get a menu at the end: move, copy, values, etc.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

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