Can you share your packaged workbook?
Did you consider writing custom sql query with DISTINCT keyword so that duplication is avoided?
Here you go! I created sample workbook. The real workbook has more data and it's performing really slow. I am joining only by school code (unique), I think I should join by school year, season, and response (?). When you look at the workbook, you'll understand. Thanks for you help!
Survey Joins.twbx 89.3 KB