I have attached a sample of data, one desired result and a picture of the layout. What I am asking to do is to not only group/sort, but maybe change the order of sorting for the next group.
The sample suggests I am planning a delivery route for two cities and four zip codes, 3 streets in those cities. I would like to be able to sort my Grouping Grid, then number each row for the sequence so I know which houses to deliver. (see map center and bottom layout)
Not every city has the same layout, this is just for demo purposes. Let''s say each city has Main Street running north to south and when travelling east or west from Main, the house numbers increase (see map). I want to drive down first street all the way from My City to Other City and drop off packages at each house. Then I want to drive up Second Street back to My City.
However, if I were to only sort by First Street, then number, I would not have the correct sequence, because the house numbers first decrease, then increase, decrease, then increase.
What I need to do is resort the house numbers when the zipcode changes. The spreadsheet attached should show better than I can explain in words. Can the GroupingEngine handle this type of sorting/grouping? Is there sample code available?
GroupingSort.zip