Hi,

I have a worsheet which includes the following columms: organization name/
donation a/ solicitor.

I would like the spreadsheet to be organized as follows:

1) Names of organizations that have an appointed solicitor.
2) Names of organizations that don't have an appointed solicitor sorted
alphabetically.

I know how to view these two seperate items individually, but how do I
include all of this on one spreadsheet as opposed to saving two copies of the
spreading with the seperate sorting requirements.

Your help would be greatly appreciated.