Results 1 to 9 of 9

Matching 2 columns from different datasets when 1 column is missing values

Threaded View

  1. #1
    Registered User
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Matching 2 columns from different datasets when 1 column is missing values

    Hi,

    I am trying to consolidate country data from two different sources. One of the sources has data on GDP growth for 252 countries. The other has data on Voice and Accountability ratings for only 216 countries. I want to get rid of Column C (country names from data set with only 216 countries) and match up Column D values to their appropriate country names in Column A.

    Thus, my goal is to keep Columns A and B the same, get rid of Column C, and get the values for Column D in the appropriate rows (some rows will be empty to represent missing countries data).

    Please let me know if you know how to do this (otherwise I will be laboriously doing this by hand). Thank you 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. compare 2 columns and create new column with missing values in second column
    By Jroelan2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-27-2012, 12:33 AM
  2. Replies: 5
    Last Post: 08-24-2012, 10:59 AM
  3. Replies: 2
    Last Post: 12-30-2011, 07:30 PM
  4. Replies: 8
    Last Post: 12-25-2011, 08:39 PM
  5. Replies: 5
    Last Post: 06-16-2005, 02:05 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