I have a problem that seems like it should be easy to solve, but I don't have enough experience in Excel to solve it.

I have thousands of data lines in the following format:

Attachment 495768


This is just an example of what the data looks like. The number of Employees assigned to each Manager could vary from 1 to 15 or more.

and I need to change the format to:

Attachment 495769



Any help is appreciated!!