Calculated Column Question

Hi there,

Can you guys please help me? I am trying to create a new calculated column that outputs all the user's vehicle. I do not think if and case when method would considering they would only look what's in the row. I used excel to show how the output should look like, please see image below:

Thanks!

Marco