I am trying to combine data from two different cells. I understand that I can
do the Concatenate formula, but I need to do it to the entire column.

For example:
ws 100
ws 200
ws 300

I know how to combine the A and B cells to be together but is there a way to
do both columns all at once (to be put in a new column).

I have a document with over 1400 items and I am really hoping that I wont
have to individually concatenate them!