I have a dataset in a Calc Sheet. I want to be able to filter so that I get the results in a very specific order.
What I have is Street Addresses and I have a “Mailman’s Route”. What I want to do is to filter or in some way order the Street Addresses so that they follow the " Mailman’s Route"
Included in the data set I have is the names of householders and what I am attempting to set up is a Spreadsheet to run through a Mail Merge program so that we create Addressed communication to the Householders.
As the “letters” are produced they are done in delivery order ie up one side of a cul de sac and down the other.
The Cul de Sac I can deal with it is the Street that the Cul de Sac runs off is the problem. I need to insert the Cul de Sac at the point on the spreadsheet so as you have a letter for the last house before the junction, then letters for the Cul de Sac, then a letter for the first house after the junction.
I know that it is possible as I have in the past used software to do it but I now no longer have access to this program.
Can some nice person help? I have attempted to use advanced filters in Calc but the result just creates a list in alphabetical order and groups all of one streets addresses together
Further to Jim K’s comment here are the files that I mentioned below along with the Mailman’s Route
I hope that this adds clarity. I have removed a lot of extra information from the spreadsheets as it is not related to my query.