Merging data within two columns into one! (& and concatenate) NOT WORKING? (FOR MY JOB NOW, URGENT :(

[sneeky]

HI I have two columns
Req | Expiry Date
yes 11/12/2010
yes 08/06/2012
yes 02/07/2017

how do i merge both columns into one.. not losing any data hence

Req Expiry Date
yes 11/12/2010
yes 08/06/2017

I am using excel 2007
PLS HELP - ITS FOR WORK!

 

[Rick Rothstein]

guys - is there a way to do this without inserting a new column for the formula - its not allowing me to insert a new column all the time as 'to prevent possible data loss, excel cannot shift non blank cells off the worksheet....
obviously i cannot remove blank cells?

You have two columns of information... which column did you want the result in and what should be done with the other column then?

 

[sneeky]

it can be in any column, i will delete the redundant once data is merged... ?
i just can't seem insert a new column all the time due to what i mentioned in last message - but the formula works if i can insert a new column. STUCK :/

 

[VoG]

This may help you Error message: To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet

 

[sneeky]

This may help you Error message: To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet

That doesn't help. I have manager to insert a few columns; now it's coming up with this rid. message.. i''m not trying to shift nonblank cells OFF THE WORKSHEET! its still the same sheet, just inserting a column between the two split columns which i need to merge... :/

 

[sneeky]

That doesn't help. I have manager to insert a few columns; now it's coming up with this rid. message.. i''m not trying to shift nonblank cells OFF THE WORKSHEET! its still the same sheet, just inserting a column between the two split columns which i need to merge... :/

Common sense. Some employee stupid enough to fill the whole sheet!
so i copied the data into a new spreadsheet and was able to insert new columns.
Thanks again guys!