Once combined, you need to change the merged data to values using copy and paste so you can delete ... columns of data in Microsoft Excel into a single column without losing that data.