Can I sort by Range Name?

[DeepSouthRick]

I have a complicated spreadsheet that contains what I'll call "su
heads" and I need to sort by these. For example, I have this sort o
data:

Owner Name Pets Pet Age
-------------------------------------
Randy's Pets
Dog 3
Cat 5

Tim's Pets
Cat 4
Bird 9

Sue's Pets
Goldfish 1


How could I sort by the Owner Name, and retain the informatio
organization under each name? Currently, all I get it is this result:

Owner Name Pets Pet Age
-------------------------------------
Randy's Pets
Sue's Pets
Tim's Pets
Bird 9
Cat 4
Cat 5
Dog 3
Goldfish 1



What I need is this result:

Owner Name Pets Pet Age
-------------------------------------
Randy's Pets
Cat 5
Dog 3

Sue's Pets
Goldfish 1


Tim's Pets
Bird 9
Cat

 

[Myrna Larson]

Use a separate column for the name, say column D. Replicate the name in all
rows that pertain to that person. i.e. D35 would all say "Randy". Now sort
all 4 columns, using column D as the key.