Sorting items in a table

Hi guys,

I've got this table that I want to sort. I've got it formatted as a table in Excel 07.

A B Description
1 1 Sunbake
2 4 Make Sandcastle
3 5 Apply Sunscreen
4 6 Sip Coconut Mocktail
5 2 Play with kids
6 6 Seashells
7 2 Starfish
8 3 Swim
9 1 Snorkel
2 Surf
3 Boogieboarding
4 Eat Icecream
1 Play beach volleyball

I'd like to sort the table where all the 1's are together and in line with column A ie..

A B Description
1 1 Sunbake
1 Snorkel
1 Play beach volleyball
2 2 Play with kids
2 Starfish
2 Surf
3
4 4 Make Sandcastle
4 Eat Icecream
5 5 Apply Sunscreen
6 6 Sip Coconut Mocktail
6 Seashells
7
8
9

Can anyone help me figure out how to do this?

Thanks in advance[ATTACH][ATTACH]Attachment 31641[/ATTACH][/ATTACH]

You can sort column B using built-in sort option.
You need a formula in column A to flag first occurance of each group.

Your main problem is the creation of groups that have no data.