Results 1 to 2 of 2

Formula to merge like values in a column

Threaded View

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    50

    Formula to merge like values in a column

    Please see the attached excel file for an example of my situation.

    In column A, One of three programs (101, 102, 103) is repeated for each country that participates in the program(column b). I'm hoping to find a formula that will merge all like values in column A, only showing the program number once for every country that participates in that program - the table to the right is how I would want it to appear.

    I am desperate for a formula for this due to the fact that (1) my data set is so large and (2) When I merge them manually and try to filter by a program, only one of the associated countries shows up.

    Any assistance would be greatly appreciated!
    Attached Files Attached Files

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1