I have five tables that I've been sorting with the merge data function. Each table 1-5 has cumulative data from the prior table. For example, table 1 shows 10 people are eligble to retire in one year, then table two has 20 people eligible to retire in 2 years (that also includes the same 10 people from table 1). I want to create a single table that has all the people eligible retire in 5 years, but for each person the number of years in which they are first eligble to retire.
I merge a sort two tables at a time (e.g. take table 5, merge with table 4, sort for duplicates and filter out duplicates), then press close and apply. More closly, table 5 has 50 entries after I merge and filter out duplicates I am left with 100 entries. Then I take table 4 merge with table 3, sort for duplicates and filter out duplicates)..... then when i go to close and apply the data in table 5 reverts back to the original number of entries (i.e. 50 entries).
Thoughts on what i'm doing wrong and/or how i can create one table showing people (by name) and the first year they are eligible to retire?
