I have a problem that seems like there should be an easy answer... but
i just can't figure it out... there might not be answer...

The situation:

In column A all of my company's employee numbers are listed (about
3000).

In column B, all of the employee numbers are listed again... however
they repeat depending on the number of degrees that employee has. For
instance, an employee will have 2 rows in column B if they have a BA
and an MS.

Column B, therefore, has about 8,000 rows.

What I would like to have is the employee number in column A line up
with the first instance of that same employee number in column B.
Blank cells would somehow "appear" in column A so that the values in
column A line up accordingly with the values in column B.

Is this even possible without a TON of manual insertion?