Here is the resulting table:
I decided to create a second table, colour coding the surnames with the country of birth of that ancestor.
This colour coded surname table demonstrates that most of the 'gaps' at the 4th great-grandparent level are in Ireland, due to the scarcity of Irish records in the early 1800s and before. Additionally, it illustrates how I can have so many 5th-to-distant-cousin DNA matches with no known shared surnames, because I have 17 4th great grandparents with an unknown surname.
© 2018. Australian Genealogy Journeys. This post was originally published at https://ausgenjourneys.blogspot.com/2018/12/a-surname-table.html
The idea for the surname table came from Our Surname Tables for DNA Research at the Family History Fanatics blog.