Excel - How to merge several rows into a single one

December 2016



Issue



In my Excel sheet , I have Names in row A and address in B, I want to merge both of them in as singe row?

Solution


Suppose the data starts from row no. 2, with row 1 having the column headings:
  • in C2 or any empty cell in the same row copy this formula
  • =A2&" "&B2
  • Copy c2 down



Thanks to venkat1926 for this tip on the forum.

Related :

This document entitled « Excel - How to merge several rows into a single one » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.