+ Reply to Thread
Results 1 to 6 of 6

How to arrange two columns like this

  1. #1
    Registered User
    Join Date
    03-15-2015
    Location
    Espaņa
    MS-Off Ver
    2013
    Posts
    80

    Question How to arrange two columns like this

    Hi there,

    I have a table with two columns like these:

    1
    2
    4 1
    3
    2
    3
    5 4
    5

    I need to get it arrange the table like this, the second column should follow the pattern of the first one, it doesn't matter the order, nor the blank spaces, they should remain exactly the same, I need the second column to basically reproduce the first one, of course the same data is in both columns, so it can compare the expressions inside and arrange them that way:

    1 1
    2 2
    4 4
    3 3
    5 5

    The thing is, there are more than two columns, these are 'assigned' to column two like this:

    1
    2
    4 1 some data here some data here
    3 some data here some data here
    2 some data here some data here
    3
    5 4 some data here some data here
    5 some data here some data here

    So I'd need not only the second column to be arranged, but also 'its content' which is in the other columns... To achieve this:

    1 1 some data here some data here
    2 2 some data here some data here
    4 4 some data here some data here
    3 3 some data here some data here
    5 5 some data here some data here

    How can I do this? I'd highly appreciate any advise,

    Regards.
    Last edited by elbrujo; 04-23-2015 at 03:18 PM.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365 ProPlus
    Posts
    9,530

    Re: How to arrange two columns like this

    You may try this....

    Please Login or Register  to view this content.
    and copy across and down.

    See the attached.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: How to arrange two columns like this

    Hi,
    Could you please upload the workbook with sample data....
    Lokesh Kumar
    Stay Hungry.. Stay Foolish..
    _________________________________________________________
    Please Click STAR to Add Reputation if my/someone's answer helped!

  4. #4
    Registered User
    Join Date
    03-15-2015
    Location
    Espaņa
    MS-Off Ver
    2013
    Posts
    80

    Re: How to arrange two columns like this

    Hello sktneer
    It worked just fine! thank you very much!

    And thank you as well Lokesh. Now I have another concern and your advise might be very helpful my friend.

    Please guys see the table attached.

    I've uploaded a sample workbook with two sheets, one with the issue, and the other one with the result I need,
    Any advise?

    Thank you.

    (Edit: Where the yellow/green rows collide with the other yellow/green rows, certainly that's different data they contain, as shown in the workbook, one contains data for "data1" and the other one for "data2", and so on... So they must autofill only the ones they belong to...)
    Attached Files Attached Files
    Last edited by elbrujo; 04-23-2015 at 05:05 AM.

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365 ProPlus
    Posts
    9,530

    Re: How to arrange two columns like this

    See the attached.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-15-2015
    Location
    Espaņa
    MS-Off Ver
    2013
    Posts
    80

    Re: How to arrange two columns like this

    Thanks! I finally could do it!
    Last edited by elbrujo; 04-23-2015 at 03:18 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort two columns (names) with keeping data intregity and order within the columns
    By ikindaknow in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2015, 10:01 AM
  2. Replies: 7
    Last Post: 04-23-2014, 10:45 AM
  3. Replies: 0
    Last Post: 03-19-2013, 12:23 AM
  4. [SOLVED] Generate "ascending order no" for columns of data that are not in order
    By abreichenbach in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-20-2013, 02:22 AM
  5. Listbox with multi-columns what determines the order of the columns?
    By jwright650 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-09-2011, 03:43 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1