Arranging LIKE data from a RANGE

[all4excel]

Arranging LIKE data from a RANGE

Ex:- This is the type of data:
The Column B is formed by the Process on the LEFT and the Activity on the RIGHT.
= PROCESS & "-" & ACTIVITY
--------------------------------------------------------
Column A Column B
1 Logistics-Reading Email
2 HR & Administration-Strategy Planning
3 New Store Projects-Conference call
4 Logistics-Meeting (Team)
5 Quality Assurance-Conference call
6 Market-Reading Email
7 Vendor Development-Meeting (Team)
8 Travel-Meeting (Team)
9 Media & Online Planning-Reading Email
10 Market-Meeting (Team)
11 Home Sourcing-Meeting (Team)
12 ID &BE-Meeting (Team)
13 Country Office-Conference call
14 Legal-Presentation
15 Vendor Development-Break
16 Travel-Break
17 Logistics-Strategy Planning
18 Retail-POP Processing-Brain storming
19 Corporate Art-Meeting (Team)
20 Retail-POP Processing-Reading Email
---------------------------------------------------------

Now what I want is to have all the data for Each Process getting arranged as follows :
---------------------------------------------------------
Column A Column B

1 Logistics-Meeting (Team)
2 Logistics-Reading Email
3 Logistics-Strategy Planning
4 HR & Administration-Strategy Planning
5 New Store Projects-Conference call
6 Quality Assurance-Conference call
7 Market-Reading Email
8 Market-Meeting (Team)
9 Vendor Development-Break
10 Vendor Development-Meeting (Team)
11 Travel-Meeting (Team)
12 Travel-Break
13 Media & Online Planning-Reading Email
14 Home Sourcing-Meeting (Team)
15 ID &BE-Meeting (Team)
16 Country Office-Conference call
17 Legal-Presentation
18 Retail-POP Processing-Brain storming
19 Retail-POP Processing-Reading Email
20 Corporate Art-Meeting (Team)
=============================================

All the processes which are same should be put together, however it should be in the same order as in the main DATA range.

Like the process which falls first in the main DATA would appear first and the remaining Activities would go in the next rows and after that when allthe activities are over the next process from the main list should appear and its corresponding activities.

[all4excel]

Please anyone has a solution

The First portion before the "-" is PRocess and which is exclusive and all the Processes should be clustered together based on their occurence in the Main Data..

[ChemistB]

You can sort by custom list. First you need to make the custom list in the order in which you want.

I'd suggest using Advanced Filter, unique records only.
Highlight your column A (your list)
Data>Advanced Filter
Copy to another location (somewhere off to the right of your spreadsheet)
No criteria
Unique records only

Then highlight this new list and from Tools>Options> Custom Lists
Import this new list.
If you add new unique items to column A later, you can update this list manually.

Now highlight columns A and B and Data>Sort
Click on Options and instead of Normal, pick the list you just created.

ChemistB

[all4excel]

I want this to be done programmatically.

Is it possible to arrange the data as specified above dynamically as this range is always going to change..

The Like Processes should be clustered together in the way they appear in the Main Data.
For Ex:- the Logistcis should come first in the result and all the Logistics with different activities will get displayed and then HR & Administration...