+ Reply to Thread
Results 1 to 4 of 4

Column rearrangement

  1. 03-06-2013, 03:34 PM #1
    Indi_Ra
    Indi_Ra is offline
    Banned User!
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    2013, 2016
    Posts
    318

    Column rearrangement

    Hi,

    How could I do this:

    col A---------------result in col B

    TT076765-1.GH---- TT076765-1.GH
    TT076767-1.GH---- TT076767-1.GH, TT076767-2.GH, TT076767-3.GH
    TT076767-2.GH
    TT076767-3.GH
    TT076799-1.GH---- TT076799-1.GH, TT076799-2.GH
    TT076799-2.GH


    I want a solution with formulas and/or VBA

    Thanks.
    Last edited by Indi_Ra; 03-06-2013 at 03:52 PM.
    Reply With QuoteRegister To Reply
  2. 03-06-2013, 11:15 PM #2
    Dunc3142
    Dunc3142 is offline
    Valued Forum Contributor Dunc3142's Avatar
    Join Date
    09-05-2007
    Location
    Franklin OH
    MS-Off Ver
    2000 and 2007 and 2010 @ Home & Teach 2010
    Posts
    351

    Re: Column rearrangement

    See if this works for you. See Attached.
    Attached Files Attached Files
    Yes it will. we just have to figure out how...
    If I have helped you, PLEASE click the * and add to my Rep.
    Also, if the problem is SOLVED please mark it as so.
    Reply With QuoteRegister To Reply
  3. 03-07-2013, 05:34 AM #3
    Indi_Ra
    Indi_Ra is offline
    Banned User!
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    2013, 2016
    Posts
    318

    Re: Column rearrangement

    Hi Dunc3142,

    Thank for this solution. I need one formula for all, cause have 6, 8 and 12 identical value in column A.
    Thanks again.
    Reply With QuoteRegister To Reply
  4. 03-07-2013, 05:35 AM #4
    Indi_Ra
    Indi_Ra is offline
    Banned User!
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    2013, 2016
    Posts
    318

    Re: Column rearrangement

    For some reason my replay was doubled.
    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