column data to rows for unique values

Hi,

I have a row of 10k lines which has values in Column A which are repeated if Column B has a value:

i.e.
Column A/B

John Audi
John BMW
Paul Audi
Ian Nissan
Ian Toyota

I need the data for Column B to be on the same row for each unique value of Column A i.e.

John Audi BMW
Paul Audi
Ian Nissan Toyota

Can anyone help? I tried Transpose however it doesn't know how to look for the unique values in Column A

assuming A1 was Jon and B1 BMW and A2 was Jon and B2 was Audi

I would put in C1 =if(A2=A1,B2,"")

Copy that right for every the max number of names you have meaning if the max amount of names was Jon at 5 then i could copy that from C1 to G1

Then coppy down how ever many rows of data make sureyou have all the from C1 to what ever max is assume G1 highlighted before you coppy down.

then if you wanted to delete the data what i would do is if G1 was the last col used I would put in H1

=if(A2=A1,"yes","no")

put everything it into a data table and select yes in h1 to autofilter

go to the number of the rows and higlight 2 and press ctrl+shift+arrowdown

then delete all rows

then select yes

and it should be the way you want it.

simpler way if you can is hgihlight col A

find special duplicates

and then delete rows