Joining and deleteing lines

Closed
-
Hi,

I wonder if you can help me, I've got some software the produces a table similar to the below where if the user has more than one car, it puts the details on the next line but leaves all other columns blank, what I'd like to do is add the car registration numbers (there could be up to 10) into one cell like below, is that possible?

Original

First name Surname Car reg
John Smith X12343
Andrew Smith Y73738
Tom Jones P32636
R35355
Alex Ford S53135


Revised

First name Surname Car reg
John Smith X12343
Andrew Smith Y73738
Tom Jones P32636, R35355
Alex Ford S53135

Thanks