Combining cells based on value of adjacent cell.

[Gav-UK]

Hey there.... I'm new to the forums so please be gentle with me

I have been reading through trying to find a similar post but the nearest i could find was one dealing with numbers rather than text.....

This is how the workbook looks...

Column A contains a list of numbers based on vehicle types

Column B contains a list of vehicle names

A B
1 Car,
1 Taxi,
2 Bus,
2 Lorry,
3 Skateboard,
3 Bike,
1 Motorcycle,


What I am looking for is the best way to combine the text from column B depending on the value of column a.

the finished results would then end up as: "Car,Taxi,Motorcycle,", or "Bus,Lorry," etc.......

This is just a simple list.. The one I am working with has around 2500 entries. I have been trying to do this using the CONCATENATE function and IF statement but it's just not working..... My head is ready to explode

Can someone point me in the right direction?

TIA

Gav.