Repeating title creation and suppression

The data in this worksheet appears to have been set up for printing purposes.…Rather than repeating the department name over and over and over again in column A,…we only see it referenced once at the beginning of the department.…So by implication, these people here are in the ADC department, these people in…the Admin Training department and so on.…And it's potentially a huge list.…And it is easier on the eyes when we are working with this data on the printed page.…Now as it turns out we are going to be adding more data eventually here.…

And the problem is if we sort the data.…Suppose we put in a new column that's salary or building or something like that…and we sort the data.…We will not be able to sort the data by department again because these are blank.…What we'd like to do now is to fill this in.…Now this could be somewhat tedious and it could be thousands of rows.…It's going to take a while.…So pulling together a variety of tips at once, let's talk about a couple of ideas.…If we could some how select just the cells in here that don't have data,…