There may be times when a business proposal or report you need to write needs data that is kept in two or more separate Excel worksheets. Fortunately there a couple of ways you can combine multiple ...

Copy all of the cells from the original column to the first new column. Select the character that divides the data. Depending on your data, this could be a space, a comma, a dash or another character.