Concatenating Data

Good day everyone...

Need help pleaae.
In column F i have different formula manually depends on data availability.
All i need is in one formula only with the same result to avoid copying formula manually.

Any solution are ok as long as with the same results

Thanks,

See attached file with provided samples data.

Try this in F6:

Please Login or Register  to view this content.

Thanks 63falcondude, only adjustment on UK row

Thanks Bo_Ry, working exactly...