URGENT: how Move all column data to row
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: URGENT: how Move all column data to row

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

    Default

     
    Case:
    a data sheet with B1-Z1 as Vendor name;
    and A2-A100 as Item number;
    And B2-Z100 are their corresonding qty

    If i want to move row1, i.e.B1-Z1's vendor name, into columnA and columnA to Row1 and all data move their corresponding cells.
    How can I do that and it is better send me the Macro example.
    Thanks a lot.
    my email is :

    cl.wong@hongkong.com

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi clwong

    If I understand you correctly, you can do this by copy and paste.

    Copy the array then use Paste Special and tick the Transpose box

    regards
    Derek

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

    Default

    Derek;
    Thanks for your great help.
    But my case is more complicated.
    could i send u the file?
    thanks

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sure,
    d.baldry@path.com.au
    regards
    Derek

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

    Default

    Derek,
    Already sent.
    Thanks.

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    There was no file attached to your e-mail. Please resend to me
    regards
    Derek

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Wouldn't it be easier to post some example data ?
    Regards,

    Juan Pablo González
    http://www.juanpg.com

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

    Default

    Hi clwong


    Try creating a Pivot Table of your data, then Pivot it until it transposed to how you want. Then just 'Copy Paste Special Values' to convert back to raw data.




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

    Default

    Thanks all.
    already done.

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

    Default

      
    dear all,

    sorry is me again.
    after testing for a datasheet with over 256rows, it doesn't work when copy and paste special with transpose.

    Error as following:
    The information cannot be pasted because the Copy area and teh paste area are not the same size and shape. Try one of the following:.......

    any other solution? Thanks.

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