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.