+ Reply to Thread
Results 1 to 5 of 5

excel transpose rows and duplicate first cell

  1. 11-08-2012, 06:21 AM #1
    bencio82
    bencio82 is offline
    Registered User
    Join Date
    11-08-2012
    Location
    Italy
    MS-Off Ver
    Excel 2007
    Posts
    2

    excel transpose rows and duplicate first cell

    hi all,
    referring to this topic as starting example http://www.excelforum.com/excel-gene...st-column.html
    what i need to do is the exact opposite, so for example i've got this:
    Col1 col2 col3 ...
    Mississippi Jackson
    Florida Orlando Tampa Jacksonville Pensacola Miami
    Georgia Atlanta
    Louisiana New Orleans Baton Rouge
    Alabama Birmingham Mobile Montgomery

    and i need this:

    Mississippi Jackson
    Florida Orlando
    Florida Tampa
    Florida Jacksonville
    Florida Pensacola
    Florida Miami
    Georgia Atlanta
    Louisiana New Orleans
    Louisiana Baton Rouge
    Alabama Birmingham
    Alabama Mobile
    Alabama Montgomery


    any hint on how to do that?
    Reply With QuoteRegister To Reply
  2. 11-08-2012, 06:37 AM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: excel transpose rows and duplicate first cell

    Bastard82,

    I have PM'd you regarding the username. Once you reply, we can proceed with providing you a solution.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  3. 11-08-2012, 06:56 AM #3
    bencio82
    bencio82 is offline
    Registered User
    Join Date
    11-08-2012
    Location
    Italy
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: excel transpose rows and duplicate first cell

    hi all, i've tried some modifications to the solution posted in the threadlinked previously and i came out with this solution.
    it seems perfectly working; if you have alternative suggestions or how to make the code works better, feel free to post them.

    thank you

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 11-08-2012, 07:18 AM #4
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: excel transpose rows and duplicate first cell

    I have sent forth your name change request to the tech team.

    Why do you want to change the macro? Is it not working well for you? Is it slow?
    Reply With QuoteRegister To Reply
  5. 11-08-2012, 07:22 AM #5
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,551

    Re: excel transpose rows and duplicate first cell

    You need to remove the +1 from the do until 

    Please Login or Register  to view this content.
    or heres another option

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1