|Column A - 2009 Attendee SSNs|
Column B - The amount paid by Attendee in 2009
Column C - 2010 Attendee SSNs
Column D - The amount paid by Attendee in 2010
Column A and Column C have some overlapping individuals, but, Column A is longer than Column C, and some people who attended in Column A 2009, did not attend in Column C 2010
I need one list, either on Column E or on a separate tab, that has one consolidated list of all attendees (2009 and 2010) with no duplicates; but for the people who attended in both 2009 and 2010, tell me how much they paid in both years
So, the new list takes up Columns E, F, and G; where E is the individual's SSN; F is the amount they paid in 2009, and G is the amount they paid in 2010
So, if Column A Line 13 matches Column C Line 45; I need Column E to list the information from Column A LIne 13 (which is the same information from Column C line 45); and I need Column F to list the information in Column B line 13 and I need Column G to list the information in Column D Line 13.
Is there anyway to do this in an automated way?