How to merge two columns & replace contents of cells conditionally?
I have a challenge in MS-Excel 2010.
I have two columns that I need to merge and data in each cell overwritten conditionally (plz. see attached sample spreadsheet).
I am working on a key engagement and need to solve this ASAP, and greatly appreciate any help.
I believe my querry is pretty simple and can be solved by somebody and may take just a couple of mins. for someone here to suggest how to solve it.
Thanks a ton!
|