Results 1 to 2 of 2

Sort numbers in column A in ascending order and the concatenate with its weights present B

Threaded View

  1. #1
    Registered User
    Join Date
    06-05-2012
    Location
    mumbai
    MS-Off Ver
    Excel 2007
    Posts
    60

    Sort numbers in column A in ascending order and the concatenate with its weights present B

    This is what I have in my two columns:-

    Column A
    Medicine ID
    1326| 323| 1442
    1321| 320| 2447| 1442|2743|
    100| 323| 1362| 152


    Column B
    Medicine weight

    500mg|2mg|60mg
    125mg|2mg|60mg|30mg|34mg
    500mg|2mg|10mg|30mg



    This is what I want:-

    Medicine ID|Medicine weight

    323 2mg|1326 500mg|1442 60mg
    320 2mg|1321 125mg|1442 30mg|2447 60mg|2743 34mg
    100 500mg|152 30mg|323 2mg |2447 60mg

    Column A contains Medicine ID
    Column B contains Medicine weight
    I want to Sort Medicine ID in ascending order and concatenate with its appropriate weight.

    Note: in the data number of medicine IDs varies from 1 to 15 and have same number of Medicine Weights. so I need formula which will work for different different number of medicine IDs



    Thanks in advance !
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort numbers in ascending order and the concatenate
    By sandubandu in forum Excel General
    Replies: 10
    Last Post: 01-16-2016, 03:11 AM
  2. [SOLVED] How to sort a column from ascending order that has doubles in it???
    By greenfox74 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-25-2015, 10:54 PM
  3. Replies: 16
    Last Post: 07-17-2015, 04:16 PM
  4. [SOLVED] Find column location by header and then sort rows below it be ascending order
    By Boo123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-04-2015, 11:58 AM
  5. Replies: 0
    Last Post: 07-11-2012, 08:28 PM
  6. Sort the numbers in ascending order by lines
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-15-2012, 04:54 PM
  7. How to get a column of numbers in ascending order?
    By walrasianxl in forum Excel General
    Replies: 2
    Last Post: 09-14-2010, 08:59 AM

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