In this tutorial, we will guide you to learn the steps to Combine or Merge Multiple Columns or Rows in Excel Office 365 using Kutools. Let’s see them below!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Note: kutools for Excel has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
Merge Multiple Columns into One Column:
If you want to merge multiple columns into one column without losing data, please do as follows.
- First, you need to select the cells that you want to merge or combine based on columns.
- On the Kutools Tab, select the Merge & Split option, then choose the Combine Rows, Columns or Cells without Losing Data option from the menu.
- Then, it will open the Combine Rows, Columns or Cells without Losing Data Dialog Box.
- In this dialog box, you need to specify the configurations as follows.
- To combine selected cells according to following options – In this section, you need to check the Combine columns option.
- Specify a separator – You can select any one of the options under this section. Here, we choose the Space option.
- Place the results to – ** You need to **select the place where you want to place the output from the drop-down list.
- Options – Here, you can see the following three options and you need to choose one of them.
- *Keep contents of combined cells – * It will not remove the contents from the original cells.
- *Delete contents of combined cells – * This will delete the contents from the original cells.
- *Merge the combined cells – * It will delete the contents from the original cells and combine them (we choose this option).
- Finally, click the OK button to see the results according to your specifications.
- Refer to the below image.
Combine Rows without Losing Data:
To combine multiple rows into one row without losing data, follow the below steps.
- You need to select the cells that you want to merge based on rows.
- Go to the Kutools Tab, select the Merge & Split option, then choose the Combine Rows, Columns or Cells without Losing Data option from the menu.
- Then, it will open the Combine Rows, Columns or Cells without Losing Data Dialog Box.
- Kindly, specify the settings as follows.
- To combine selected cells according to following options – In this section, you need to check the Combine rows option.
- Specify a separator – You can select any one of the options under this section. Here, we choose the Space option.
- Place the results to – ** You need to **select the place where you want to place the output from the drop-down list.
- Options – Here, you can see the following three options and you need to choose one of them.
- *Keep contents of combined cells – * It will not remove the contents from the original cells (we choose this option).
- *Delete contents of combined cells – * This will delete the contents from the original cells.
- *Merge the combined cells – * It will delete the contents from the original cells and combine them.
- At last, you need to click the OK button to get the result as shown in the below image.
Merge Selected Cells into Single Cell:
To merge multiple columns and rows into a single cell in Excel, follow the below steps.
- You need to select the cells that you want to merge.
- Go to the Kutools Tab, select the Merge & Split option, then choose the Combine Rows, Columns or Cells without Losing Data option from the menu.
- Then, it will open the Combine Rows, Columns or Cells without Losing Data Dialog Box.
- Now, configure the settings as follows.
- To combine selected cells according to following options – In this section, you need to check the Combine into single cell option.
- Then, specify the separator to delimit the combined contents.
- After that, you need to click the OK button.
- You will get the result as shown in the below screenshot.
Conclusion:
In this tutorial, we guided you to know the steps to Combine or Merge Multiple Columns or Rows in Excel Office 365 using Kutools. ** Kindly, share your **feedback/suggestions in the below comment section. Thanks for visiting Geek Excel. Keep Learning!
Top comments (0)