I have two columns that a client has sent me... unfortunately some contents are on another column. I want to make it so that all the data lines up in just column... how do I make this happen?
On a COPY of your workbook, I'd set up a formula in column G that concatenates the values in columns E and F, trims any excess "white" space or blank space (just in case), then copy and 'paste special /values' the results in G back into E.
Your formula in cell G1 might be =TRIM(CONCATENATE(E1,F1))
Or, use the ampersand (&) operator to concatenate: = TRIM(E1 & F1).
I personally prefer the "&" operator.
Here is another choice, though it won't work if there is any other data to the right of this section of your spreadsheet.