Custom Sort Order - Series Data

I have looked online everywhere for this answer - I feel like it's very simple, and perhaps I'm just not searching the right terms.

I have a 4 column spreadsheet of events.

Column A = Title
Column B = Start Date
Column C = End Date
Column D = Location

Each Location has 6 events going on at any given time. I need to sort Column D in a specific order by Location - but not the way Excel would typically do it with a Custom List.

I do NOT want:

Location A
Location A
Location A
Location B
Location B
Location B
Location C
Location C
Location C

I DO want to sort this column (and its associated other columns for a given row) to have this order:

Location A
Location B
Location C
Location A
Location B
Location C
Location A
Location B
Location C

Is this possible?

Thanks!

Thanks for the quick reply! Unfortunately, this doesn't work 100% and it may just be because I'm not explaining it correctly.

Assigning a helper column in this way will group the locations together, but doesn't always put them in the same order (how would Excel know the proper order if all 3 have the same value? This appears to only group them, but not sort them within that group).

Maybe a real life example is the only way to go -

Here is the current spreadsheet: http://thinkforwardstudios.com/wp-co...ay-flavors.csv

In Column D, you can see there are 6 values repeated throughout the column. I need them to be in the same, albiet repeated, order. It doesn't matter which Location comes first, just that they are in a consistent order.

For example, the spreadsheet should sort the data aligned as follows (order not important, but the consistency of the given order is important, FYI):

Sheridan Drive
Main Street
Union Road
Niagara Falls Boulevard
Transit Road
Delaware Avenue
Sheridan Drive
Main Street
Union Road
Niagara Falls Boulevard
Transit Road
Delaware Avenue
Sheridan Drive
Main Street
Union Road
Niagara Falls Boulevard
Transit Road
Delaware Avenue
Sheridan Drive
Main Street
Union Road
Niagara Falls Boulevard
Transit Road
Delaware Avenue
Sheridan Drive
Main Street
Union Road
Niagara Falls Boulevard
Transit Road
Delaware Avenue
Sheridan Drive
Main Street
Union Road
Niagara Falls Boulevard
Transit Road
Delaware Avenue

As you can see, all 6 locations are represented and the block of 6 locations has the same repeating order. This is what I'm looking for. Now, because there are also dates associated and those also need to be in order, I thought a simple sort by date and then by location would work, but it does not.

I have 6 simultaneous all-day "flavors" going on, one at each location, and I'd like the data to have all of the first set of dates together, in order, along with location - location being the more important (consistent) factor. In other words, because some dates may not line up 100%, the location should always line up.

Are you following me?

Thanks again!

Nevermind, that actually did it for me! Thanks so much!