Potential combination of LookUp and DeDupe to create multiple values in a single cell

Is it possible to look up a cell in one tab against another, find multiple instances of the number, then using a different column pick out unique value and combine the unique values into a cell on the original tab?

Hopefully the below helps clarify.

Table 1 contains the reference number i want to look up:

Reference Value
1
2
3
4

Table 2 contains the values i need for my final table against the reference number i am looking up. A reference can have multiple values

Reference Value
1 Car
2 Car
3 Car
4 Car
1 Car
1 Bus
1 Train
4 Bus

Table 3 shows the end result. For each reference number the values are merged into one cell allowing one line for each reference.

Reference Result
1 Car;Bus; Train
2 Car
3 Car
4 Car;Bus

Hopefully someone has done something similar to this before. If i need to provide any further clarity, please let me know.

Kris