If you have data that has blanks in it you may be able to combine columns using Paste Special – Skip Blanks.

It depends what your data looks like whether this technique will help – see the video for the requirements.