Copy Data in column B to other columns dependent on Contents of column A

Hi,

I have two columns of data Starting in A1 and B1.


Column A has email addresses and column B has ID numbers.


At the moment if a person has more than one id their email address appears twice in column A.


I want to end up with one email address per person and instead of all the id numbers being in column B copy them across into column C, D, E etc. there could be up to 10 Id's.

If anyone could help I would be grateful.

Example attached.