Sorting with sub catagories

[John Gray]

I have a simple spreadsheet that lists some hospital departments and then
under some of the departments i have sub-departments. I'm looking for a way
to sort alphabetically by department but keep the sub-departments in their
correct position. Hopefully this makes sence...

Thanks everyone,
John Gray

 

[ShaneDevenshire]

Hi,

Show us the layout of the data
A
Dept1
sub1
sub2
sub3
Dept2
sub1


or

A B
Dept1
sub1
sub2

If the first case - how do you tell one dept from a sub-department?

 

[John Gray]

It's like the first one, everthing in one column. Now we can move
subcatagories to a second column but right not there not.
Dept1
Sub 1
Sub 2
Dept2
Sub 1
Sub 2
Sub 3
Dept3

Nowwhen i sort this (even though my example is already correct) i want the
sub to always stay under there correct dept.