how can i concatenate many cell in one cell

[inspectoRQ]

hi all!

example
a b c d
id name car
0141 john toyota
0186 chris mercedes
0141 john crysler
0141 john bmw
0112 marry range rover
0116 john(b) wolkvagen


how can i concatenate the all cars belongs one id in cell d?assume that there are thousands of cells like these

 

[Aladin Akyurek]

wow it works. i really apreciated it. thanks lot. (Allah razı olsun)

You are welcome. Thanks for providing feedback.