You need to have column A showing relevant department in each cell too.

here is one way to quickly copy the departments to rows below.

Select column A and then hold the CTRL key and select A1.

Then go to Edit|Go To and click Special....select Blanks and click Ok.

enter an = sign and hit the up arrow key.

Hold the CTRL key again and hit ENTER.

You may have to fix whatever was in A1.