I currently have two columns of strings like the following. And want to concatenate the two columns together to make the third using Power Query. I have been trying to find a way for several days with no luck. If a way could be found using DAX I would accept that solution as well.

enter image description here

I have tried several different “list.*” type functions, and tried to use different text functions with no avail.