I have two columns one with a single employee id and the second column is the
employee name for several rows something like this:

1234 John Doe
John Doe
John Doe
3456 Jane Doe
Jane Doe
Jane Doe

How do I move the employee number down to coincide with its name and then
start the next employee and do the same thing without manually copying and
pasting.