Alright here is the situation. I have a spreadsheet which will receive
its information from a seperate exsisting spreadsheet via a query. The
exsisting spreadsheet has the following information in its column.

MLB = Minority Little Boy
B = Boy
MLG = Minority little Girl
MLG-A = Minority little Asian girl
etc.

What preceded is just a sample of the codes used in this spreadsheet.
There are several other and the importance is that it identifies the
ethnicity and sex of the child. What I need to do is to use this
information from the exsisting spreadsheet and import it into a new
spreadsheet into two different columns one for sex and one for
ethnicity. For example:

Exsiting Sheet New Sheet Col A New Sheet
Col B
MLB Male
Black
B Male
White
MLG Female
Black
MLB-H Male
Hispanic
MLG-A Female
Asian

etc..