I'm trying to run a macro to concatenate two columns J&D to column K.
Ive looked through past threads and got this far, but some of my cells are blank in column J&D but would still like to combine the data.
What do I need to change to make this happen I'm guessing its something to do with...