merge duplicate rows in excel while keeping all text

Merging into one cell will keep the upper-left most data only.' (Excel 2010, 2007)įurther in this article, you will find 3 ways that will let you merge data from several columns into one without losing data, and without using VBA macro. You will get the error message ' Merging cells only keeps the upper-left cell value, and discards the other values.' (Excel 2013) or 'The selection contains multiple data values. Of course, there is the Merge button (' Merge & Center' etc.), but if you select 2 adjacent cells in order to combine them, as shown in the screenshot: Regrettably, Excel does not provide any built-in tool to achieve this. For example, you want to merge the First Name & Last Name columns into one, or join several columns such as Street, City, Zip, State into a single 'Address' column, separating the values with a comma so that you can print the addresses on envelops later. You have a table in Excel and what you want is to combine two columns, row-by-row.

From this short article you will learn how to merge multiple Excel columns into one without losing data.

Merge duplicate rows in excel while keeping all text