The clipboard Window will appear on the left side of the workbook. In the HOME tab > Clipboard section > click Icon.Here, we will use the Clipboard feature to merge two rows in Excel. Method 2: Applying Clipboard Feature to Merge Two Rows in Excel Read More: How Excel Combine Rows into One Cell (4 Methods) Finally, you will the output in the below image.Then, for the rest of the rows, you can apply the Merge & Center command.
After that, you will see the merged text named New York.If you explicitly know losing the data may not hamper you then click OK.So, There will pop up a warning window.Thirdly, click on Merge & Center command.Secondly, Merge & Center the group of commands under the Alignment group.Here, I want the name of the Provinces row to be merged into one row by using the Merge & Center feature. Method 1: Using Merge & Center Command to Merge Two Rows (It Will Lose Your Data) This article will demonstrate to merge two rows in Excel by using the Merge & center command, using the Clipboard feature, applying the CONCATENATE function, and nesting CONCATENATE & TRANSPOSE functions for two different outputs Losing Data & Intact Data.