It seems that the best way is to use autofilter.

Highlight the column headers (CODE, ACCOUNT etc) that you want to work
on (Alternatively highlight all headers). Then select from the main
menu data--autofilter. That will display little arrows next to each
header.

If you click on such an arrow Excel pops up a little listbox with all
the entries in that column (unique and sorted) plus a couple of extra
options. One is "nonblanks". Choose that and Excel will only show lines
where that column has an entries. If you continue to do that on other
columns you constantly narrow down your selection because from the
subset mentioned above it will only show the ones that meet the second
selection etc. You can sort that selection by highlighting the lines
displayed (by clicking on the row headers).

If you want to display the full set again, the quickest way is to
select the headers and select data--autofilter which will turn off
autofilter. You can then start all over as described above.

Hans