Thanks Thanks:  3
Showing results 1 to 6 of 6

Thread: Request: Excel Horizontal to Vertical

  1. #1
    VIP Member Reputation: 1228
    Join Date
    2008-06-18
    Location
    TESTBED
    Posts
    608


    Default Request: Excel Horizontal to Vertical

    Site AZ1 AZ2 AZ3 Height Address
    Site001 0 120 240 55 Address1
    Site002 10 100 250 40 Address2
    Site003 12 100 300 45 Address3
    Site004 15 140 blank 20 Address4
    Site005 18 136 300 35 Address5

    The table above is what I have.

    The table below is what I would need macro to transpose:

    Site AZ Height Address
    Site001 0 55 Address1
    Site001 120 55 Address1
    Site001 240 55 Address1
    Site002 10 40 Address2
    Site002 100 40 Address2
    Site002 250 40 Address2
    Site003 12 45 Address3
    Site003 100 45 Address3
    Site003 300 45 Address3
    Site004 15 20 Address4
    Site004 140 20 Address4
    Site005 18 35 Address5
    Site005 136 35 Address5
    Site005 300 35 Address5


    But here Site 004 has only 2 AZ and it should be copy/make only 2 rows.

    Hello Experts, Please kindly help me to get maco for Excel 2007.

    Thanks.

    BR//
    Edin

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Location
    Advertising world
    Posts
    Many
     

  3. #2
    Member Reputation: 18
    Join Date
    2014-01-28
    Posts
    7


    1 out of 1 members found this post helpful.

    Default Re: Request: Excel Horizontal to Vertical

    I've made an Excel spreadsheet with a Macro to convert the data. You can download it here: https://dl.dropboxusercontent.com/u/...pand_Data.xlsm

  4. #3
    VIP Member Reputation: 1228
    Join Date
    2008-06-18
    Location
    TESTBED
    Posts
    608


    Default Re: Request: Excel Horizontal to Vertical

    Perfect...Perfect...Perfect....

    Download and already tested...working perfect...

    Thanks and give reputation....

  5. #4
    Member Reputation: 171
    Join Date
    2008-08-14
    Location
    AT
    Posts
    384


    0 out of 1 members found this post helpful.

    Default Re: Request: Excel Horizontal to Vertical

    Quote Originally Posted by edinburgh View Post
    Site AZ1 AZ2 AZ3 Height Address
    Site001 0 120 240 55 Address1
    Site002 10 100 250 40 Address2
    Site003 12 100 300 45 Address3
    Site004 15 140 blank 20 Address4
    Site005 18 136 300 35 Address5

    The table above is what I have.

    The table below is what I would need macro to transpose:

    Site AZ Height Address
    Site001 0 55 Address1
    Site001 120 55 Address1
    Site001 240 55 Address1
    Site002 10 40 Address2
    Site002 100 40 Address2
    Site002 250 40 Address2
    Site003 12 45 Address3
    Site003 100 45 Address3
    Site003 300 45 Address3
    Site004 15 20 Address4
    Site004 140 20 Address4
    Site005 18 35 Address5
    Site005 136 35 Address5
    Site005 300 35 Address5


    But here Site 004 has only 2 AZ and it should be copy/make only 2 rows.

    Hello Experts, Please kindly help me to get maco for Excel 2007.

    Thanks.

    BR//
    Edin
    No need any macro, just copy and paste special -> select transpose

  6. #5
    VIP Member Reputation: 1228
    Join Date
    2008-06-18
    Location
    TESTBED
    Posts
    608


    Default Re: Request: Excel Horizontal to Vertical

    Everyone even idiot knows how to copy and paste...

    But Only programmer knows how to write macro for saving time...

  7. #6
    Member Reputation: 18
    Join Date
    2014-01-28
    Posts
    7


    1 out of 1 members found this post helpful.

    Default Re: Request: Excel Horizontal to Vertical

    Hi, I think Transpose only swaps rows and columns - that's not the output format @edinburgh was looking for.
    Last edited by _ct_; 2014-02-08 at 03:34 AM

Bookmarks

Bookmarks

Posting Rules

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