|If you didn't understand my response, why did you mark it as the "Best Answer"?|
Why did you repost the code from my response?
re: "I don't understand the form of your response in relation to an excel formula"
What you are trying to do cannot be done with an Excel formula because there is no set number of rows between the Employee Numbers. There is no formula that can count the rows and determine how many times to repeat the employee number.
What I suggested is known as a "macro" which is a set of VBA (Visual Basic for Applications) instructions (code) that can be run against the data in your spreadsheet.
As per the comments embedded in the code, the macro will read the data in each cell in Column A and when it finds an Employee Number, it will then count how many cells below that number do not contain a Employee Number. It then copies that Employee Number the same number of times into Column B. It then searches for the next Employee Number, counts the non-Employee Number cells and copies that Employee Number into Column B. The code continues searching for Employee Numbers, counting rows and copying Employee Numbers until it reaches the bottom of the data in Column A.
You should end up with something like this, which is what I believe you are looking for:
1 123 123
2 a 123
3 b 123
4 * 123
5 d 123
6 1111 1111
7 a 1111
8 456 456
9 a 456
10 b 456
11 c 456
To use the code, press Alt-F11 to open the VBA editor.
Paste the code I offered into the pane that opens and Run it.
I highly suggest that you try this in a backup copy of your workbook since macros can not be undone.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.