Formula help

[Stig - tame racing driver]

HI

Please see list below, out of these 4 fixed column I am trying to filter
them to make one list (column 5) of unique name (no duplicated names)

Is there a formula I can use

1 2 3 4 5
jon gary jon peter
paul des des jon
dave dave gary paul
gary paul peter gayle



Thanks