combining text of multiple cells in one automatically

I am trying to look for a easy way to combine field together. Added 2 files one is how it is imported (just a small portion) and one is how I want it to be. Any idea on how I can get this done automated? Because I later on need to be able to search on the info.

hscodeneedstobe.xlsx
hscodeold.xlsx