I'm fairly certain a Pivot Table will easily handle your request.

Here's how to start:
<Data<Pivot Table
Use: Excel
Select your data
Click the [Layout] button

ROW:
Drag the Team field here
Drag the Grade field below Team
Drag the Members field below the Grade field

DATA: Drag the People field here
If it doesn't list as Count of Members...dbl-click it and set it to Count
Click [OK]

Select where you want the Pivot Table...and you're done!

That will list each Grades and Members by Team and the count of Members.

To switch to the second view
Click the Pivot Table Wizard button
Click the [Layout] button
Drag the Grade field to above the Team field

Now you have Teams and Members listed by Grade

For an excellent tutorial on Pivot Tables, see MVP Debra Dalgleish's
contribution to Chip Pearson's website:
http://peltiertech.com/Excel/Pivots/pivotstart.htm

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


" wrote:

I know this is over my head and I am not sure Excel is the right
program, but I have had luck in the past with this group and figured
someone more knowledgable than me would know if it is or isn't
possible. What I have is some Categories that are made up of
subcategories and there is data associated with these subcategories,
such as # of people in each of these subcategories under the
categories. What I want to do is make the subcategories the categories
and the categories the subcategories under these new categories with
the appropriate data attached to the categories. Let me explain.

I have data like that below.

Soccer team (column A)
(column B has the grade and column c has the # of kids)
3rd grade - 10 people
4th grade - 20 people
7th grade - 15 people

Baseball team (column A)
(column B has the grade and column c has the # of kids)
4th grade - 5 people
7th grade - 10 people

I know want to run a formula in excel that will automatically give me
the following results.

3rd grade
Soccer team - 10 people

4th grade
Soccer team - 20 people
Baseball team - 5 people

7th grade
Soccer team - 15 people
Baseball team - 10 people

***note this is not the actual data I am flipping but it would work the
same exact way. It wouldn't be a big deal except that I have many many
pages of this and it takes me a couple hours to manipulate this.

Thanks in advance for the help. Please steer me in the right
direction.