How to Convert a Single Column or Row to Ranges/Vice Versa in Excel?
Tags: convertasinglecolumn, kutoolsexceltutorial, kutools
Published: 2020-11-20 09:53:57

---
title: How to Convert a Single Column or Row to Ranges/Vice Versa in Excel?
published: true
date: 2020-11-20 09:51:12 UTC
tags: ConvertaSingleColumn,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-convert-a-single-column-or-row-to-ranges-vice-versa-in-excel/
---

In this guide, we will show you the ways to **Convert a Single Column or Row to Ranges/Vice Versa in Excel Office 365** using **Kutools.** 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.
## Convert a Column to Multiple Columns:

To convert a column to multiple columns in Excel, do as follows.

- You need to **select a single column** that you want to convert.

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

- On the **Kutools Tab, select** the **Range** option, **choose** the **Transform Range** option from the menu.

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

- Then, it will display the **Transform Range **** Dialog box.**
- **Data to be transformed –** You need to select the input range.
- **Transform type –** In this section, you need to **select** the **Single column to range** option.
- **Rows per record –** Here, you can **choose** the **Blank cell delimits records** option or **Fixed value** option.
- Then, **click** the **OK** button.

![Transform Range Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-33.png)<figcaption id="caption-attachment-17740">Transform Range Dialog box</figcaption>

### Note:

- **Blank cell delimits records – ** You can check this option if you have selected a column with a blank cell as a separator and you want to use the blank cells as a separator to convert the column.
- **Fixed value –** It will start a new row after how many cells specified in the drop-down list.

- It will open the **Transform Range dialog box** , you need to **select** the **output range** (single-cell) to display the result and **click** the **OK** button.

![Select a cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-32.png)<figcaption id="caption-attachment-17741">Select a cell</figcaption>

- Now, you will get the result as shown in the below image.

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

## Transform a Row to Multiple Rows:

If you want to transform a single row to multiple rows in the Excel worksheet, do as follows.

- You need to **select a single row** that you want to convert into multiple rows.

![Select a single row](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-28.png)<figcaption id="caption-attachment-17744">Select a single row</figcaption>

- Go to the **Kutools Tab, select** the **Range** option, **choose** the **Transform Range** option from the menu.

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

- Then, it will open the **Transform Range **** Dialog box.**
- **Data to be transformed –** You need to select the input range.
- **Transform type –** In this section, you need to **select** the **Single row to range** option.
- **Rows per record –** Here, you can **choose** the **Blank cell delimits records** option or **Fixed value** option.
- Then, **click** the **OK** button.

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

### Note:

- **Blank cell delimits records – ** You can check this option if you have selected a row with a blank cell as a separator and you want to use the blank cells as a separator to convert the rows.
- **Fixed value –** It will start a new column after how many cells specified in the drop-down list.

- It will open the **Transform Range dialog box** , you need to **select** the **output range** (single-cell) to display the result and **click** the **OK** button.

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

- At last, you will get the output as shown in the below screenshot.

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

## Convert Multiple Columns to a Single Column:

You can easily convert multiple columns to a single column in Excel. To do this, follow the below steps.

- First, you need to **select a range** that you want to convert to a single column.

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

- On the **Kutools Tab, select** the **Range** option, **choose** the **Transform Range** option from the menu.

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

- Then, it will display the **Transform Range **** Dialog box.**
- **Data to be transformed –** You need to select the input range.
- **Transform type –** In this section, you need to **select** the **Range s**** ingle column** option.
- Then, **click** the **OK** button.

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

- It will display the **Transform Range dialog box** , you need to **select** the **output range** (single-cell) to display the result and **click** the **OK** button.

![Select a cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-14.png)<figcaption id="caption-attachment-17750">Select a cell</figcaption>

- Finally, you will get the output as shown in the below image.

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

## Transform Multiple Rows to a Single Row:

To transform multiple rows into a single row in an Excel worksheet, do as follows.

- You need to **select a range** that you want to convert to a single row.

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

- Go to the **Kutools Tab, select** the **Range** option, **choose** the **Transform Range** option from the menu.

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

- Then, it will open the **Transform Range **** Dialog box.**
- **Data to be transformed –** You need to select the input range.
- **Transform type –** In this section, you need to **select** the **Range to**  **Single row** option.
- Then, **click** the **OK** button.

![Transform Range Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/13-7.png)<figcaption id="caption-attachment-17753">Transform Range Dialog box</figcaption>

- It will display the **Transform Range dialog box** , you need to **select** the **output range** (single-cell) to display the result and **click** the **OK** button.

![Select a range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/14-7.png)<figcaption id="caption-attachment-17754">Select a range</figcaption>

- Now, you will get the result as shown in the below image.

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

## Sum-Up:

In this guide, you can easily understand the steps to **Convert a Single Column or Row to Ranges/Vice Versa in Excel Office 365** using **Kutools. ** Leave your **queries/suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Unhide All Rows and Columns in Excel Office 365?](https://geekexcel.com/how-to-unhide-all-rows-and-columns-in-excel-office-365/)
- [Find and Replace the Similar Records from a List of Cell Values in Excel](https://geekexcel.com/how-to-find-and-replace-the-similar-records-from-a-list-of-cell-values-in-excel/)