to copy and sort values into different rows based on codes

Hi
I have a set of data as follows: (these are in continuous columns)
BAACNDL DIGOUPL CHOOTXX BAACNXX
cols cells cols cells cols cells cols cells


1 1 2 2 24 24 1 5
5 10 123 26
5 10 123 5
12,000 23,000 15,000 7,000

I need to copy the values and sort them as followsbased on the beginning two letters of the code i.e. BA, CH, DI etc) - no gaps between rows for each set below.
Add a heading for this set as BACILLARIO
BAACNDL 5 5 12000
BAACNXX 26 5 7000

Add a next heading called CHLORO and then copy
CHOOTXX 123 123 15000

Add a next heading called DINO and copy the follg values:
DIGOUPL 10 10 23000


Can somebody help me with this? Thanks