Quote Originally Posted by Chas Kenyon View Post
Thank you for sharing this.
For cross-posting etiquette, please read: A Message to Forum Cross-Posters https://www.excelguru.ca/content.php?184

In the future, I think what I would suggest would be doing twenty-three merges, filtering for the location.
Apologies for the cross post without links, should have thought of that! :-)

how do you mean about 23 merges? I did wonder about filtering on location but I didn't see any way to get the list of locations (they're always different) into an array or something to then loop through?