URGENT: how Move all column data to row - Page 2
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: URGENT: how Move all column data to row

  1. #11
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi clwong


    Excel has a Column limit of 256 which cannot be increased.

    Not sure why you need to Transpose an entire table, but a Pivot Table of you data may help you out. You will of course still be bounded by 256 columns.



  2. #12
    New Member
    Join Date
    Mar 2002
    Location
    Hong Kong
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Dave Hawley

    Oh no.....as it is requested from my boss....
    any other alternative? Macro?...VBA.....

  3. #13
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    No not really, tell your boss Excel is not desingned to have data laid out this way! The best that could be done is spread it over more than one sheet (not advised), or set up a Pivot Table, then you boss will get himself confused and/or excited Pivoting the data.

    I must ask why does you boss want to Transpose an entire table???

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com