Still struggling with splitting names into groups.

People were kind enough to help the other day but I still can't get my head around a suggested solution.
I think I made things a little more complicated than they needed to be so I've attached a simplified version.

Here's the deal:
I have one list of names/score/age group
I want to produce a three sets of results based on age group (A, B or C in column "C")

Believe me, I've tried, but there comes a point where my brainpower isn't up to the task involved.

Anyway, as ever, help would be really appreciated.

scoredemo-v2.xls

Steve

OK, I'll go and take another look at that option. I did have pivot tables suggested at some point. My problem is the gap between brainpower available and brainpower required.

Well I had a look but I don't really want people having dropdown and collapsing buttons. This is for senior golfers, and simplicity is key.
The names in column A will already be in score order.

What I need is:

"Look at C3. If it equals "A" then put the contents of A3 and B3 into the first empty rows in columns E and F....if it equals "B" then use columns H and I etc....
Then look at C4 and repeat"

I'm afraid I just can't translate that into Excelese.

Thanks all.