I would add (duplicate) the Employee name for every
applicable Row but use conditional formatting to hide it (Font color =
Background).

The Auto Filter will still find all rows  but only the first Employee
name in Column A would show.

Set Conditional Format by selecting all of Column B (assuming first row
is 1) and entering =B2=B1