the dredded repeating values

[grumbachr]

I inherited 2 repeating values fields (7 values each) and need to now do some reporting on them.

The fields track Ancestry (Mothers Ancestry and Fathers Ancestry) each hold names of countries that a person ancestors come from.

The ultimate goal is to have a count of people reporting they families come from what country kind of like:

Country | count

Ireland 335

Germany 487

China 28

Switzerland 46

etc...

Since each person has 2 fields, I think I need to merge the 2 to simplify thigs. So is it possible to merge 2 repeating fields into one without having duplicate values?

Also if you have any other suggestion or advice it would be greatly appreciated.

[comment]

Import them to a new table, twice - once for each repeating field - while breaking them into separate records. Do a summary report from the new table.