How to Combine (Merge) Multiple Columns or Rows in Excel Office 365?
Tags: kutoolsexceltutorial, mergemultiplecolumns, kutools
Published: 2020-11-23 10:11:50

---
title: How to Combine (Merge) Multiple Columns or Rows in Excel Office 365?
published: true
date: 2020-11-23 07:21:16 UTC
tags: KutoolsExcelTutorial,MergeMultipleColumns,Kutools
canonical_url: https://geekexcel.com/how-to-combine-merge-multiple-columns-or-rows-in-excel-office-365/
---

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](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) 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.

![Select the cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-39.png)<figcaption id="caption-attachment-17889">Select the cells</figcaption>

- On the **Kutools Tab, select** the **Merge & Split** option, then **choose** the **Combine Rows, Columns or Cells without Losing Data** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-9.png)<figcaption id="caption-attachment-17890">Kutools Tab</figcaption>

- 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).

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-38.png)<figcaption id="caption-attachment-17893">Click OK button</figcaption>

- Finally, **click** the **OK** button to see the results according to your specifications.
- Refer to the below image.

![Merge the combined cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-37.png)<figcaption id="caption-attachment-17894">Merge the combined cells</figcaption>

## 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.

![Select the cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-39.png)<figcaption id="caption-attachment-17889">Select the cells</figcaption>

- 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.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-9.png)<figcaption id="caption-attachment-17890">Kutools Tab</figcaption>

- 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.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-33.png)<figcaption id="caption-attachment-17896">Click the OK button</figcaption>

- At last, you need to **click** the **OK** button to get the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-28.png)<figcaption id="caption-attachment-17897">Result</figcaption>

## 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.

![Select the cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-26.png)<figcaption id="caption-attachment-17898">Select the cells</figcaption>

- 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.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-9.png)<figcaption id="caption-attachment-17890">Kutools Tab</figcaption>

- 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.

![Hit the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-24.png)<figcaption id="caption-attachment-17899">Hit the OK button</figcaption>

- You will get the result as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-23.png)<figcaption id="caption-attachment-17900">Output</figcaption>

## 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.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Unhide All Rows and Columns in Excel Office 365](https://geekexcel.com/how-to-unhide-all-rows-and-columns-in-excel-office-365/)
- [How to Insert a Monthly or a Yearly Calendar in Excel Office 365?](https://geekexcel.com/how-to-insert-a-monthly-or-a-yearly-calendar-in-excel-office-365/)