Excel Hack 71: Copy and paste without overwriting existing cells
You have information about the same attribute separated across several columns. And you want to see them in one column. This is the hack for you. First, ensure the columns have blanks where the other column information exist. This is because we are about to perform a ‘skip blank’ operation in Excel. Next, copy the