Inside a cell where you want to merge the two rows enter the formula & then select the TRANSPOSE part as shown below. You have to highlight the TRANSPOSE part of the formula & it converts cell reference into cell values. =CONCATENATE(B2,", ",B3,", ",B4,", ",B5,", ",B6,", ",B7,", ",B9,", ……) 4) Using CONCATENATE & TRANSPOSE functions Ī combination of the CONCATENATE & TRANSPOSE functions can be used to merge two rows values without losing any data. In various situations, if we need to deal with multiple or numerous data CONCATENATE function can be used as follows. If you want to place a Space between the texts then use as your delimiter. Space & Comma will appear between row texts shown as in the image. Delimiters are used to separate the different texts.īy putting as a delimiter you can place Space & Comma between two rows’ elements. The CONCATENATE function or Concatenation Operator is used to merge two or more rows using various delimiter types. (Command Sequence)įor better understanding, I repeat the command sequence for rows B3, B4 again.įurther application of the command sequence for the rest of the rows, the outcome will be as in the below image.ģ) Using the CONCATENATE Function Then select the two Rows> press Ctrl+C (copy) > Select Any Cell >Double Click On it > Click on the available Item to Paste. Clipboard Window will appear on the left side of the workbook. In the HOME tab > Clipboard section > click Icon. However, the Excel Clipboard feature does the work. Normally in Excel when we select two rows and Copy(Ctrl+C). Excel has kept the upper value only.įor the rest of the rows you can apply the Merge & Center command. We can see that inside the Active Cell only the Text from the Upper Active Cell (A3) is present. If you explicitly know losing the data may not hamper you then click OK. To do that, go to the Home tab >Alignment section > Merge & Center group of commands > Merge & Center. Now, I want the name of the Provinces row to be merged into one row. Merge two rows.xlsx How to Merge Two Rows in Excel (4 Easy Ways) 1) Using Merge & Center Method (it will lose your data)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |