How to transfer vertical info from one sheet to horizontal direction (another sheet)?

Hello,
I have a sheet where in column A I have an employee number and next to it objects wich that employee owns.
In case one employee owns more than one object his number is repeated in the cell below so in the next cell it is visible the number of the second object.

I need to transfer objects owned by employee to another sheet where the structute is silghly different-I have one line per employee and if she/he owns more than one object I have extension of the data horizontally.
So in other words I need to transfer information from vertical layout to horizontal based on employee number.

What easy solution you can suggest? Bear in mind that my list is long so the formula that does this magic transfer should be just dragged right and down.
you can find the details in the attached example. Check sheet1 and 2.
Thank you!Book1.xlsm

I reviewed your file, but did not understand how to meet your needs based on was in the provided example. If you would be so kind as to provide a more specific example (and remove any identifying info), it would be more helpful in trying to help you solve your issue.

Originally Posted by LMunoz

I reviewed your file, but did not understand how to meet your needs based on was in the provided example. If you would be so kind as to provide a more specific example (and remove any identifying info), it would be more helpful in trying to help you solve your issue.

I am sorry.I have attached wrong file. That is the new one.new.xlsx

Oeldere,
Thanks for the solution. The formula is quite complicated for me. Usually I am trying to understand solution provided. Again thank you.

Gr8! Thank you.