Transpose the Data from Column to Row in Excel Office 365!!
Tags: excelbasics, excelpreface, exceltutorials, transposedata
Published: 2021-01-18 11:13:28

---
title: Transpose the Data from Column to Row in Excel Office 365!!
published: true
date: 2021-01-18 10:36:38 UTC
tags: ExcelBasics,ExcelPreface,ExcelTutorials,Transposedata
canonical_url: https://geekexcel.com/transpose-the-data-from-column-to-row-in-excel/
---

If you have a worksheet with data in a column, and you need to rearrange it in rows. How could you achieve it? Let’s come into our topic, here we will explain the simple methods used to **transpose the data from columns to rows in Excel**. 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)
## Transpose data using Paste Special Transpose:

You can use the **“Paste Special – Transpose”** option to switch rows to columns or vise versa. Let’s see how.

- First, enter the input data and select the range that you want to rearrange.

![Select range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Select-range.png)<figcaption id="caption-attachment-21130">Select range</figcaption>

- Then, press **CTRL** + **C** to copy the selected range.

![Copy the Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Copy-the-Range.png)<figcaption id="caption-attachment-21131">Copy the Range</figcaption>

- Select any cell where the result wants to begin then click the **Right-click** option.
- Here, you need to select the **“Paste Special”**.

![Paste Special](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Paste-Special.png)<figcaption id="caption-attachment-21132">Paste Special</figcaption>

- It will open the window as shown below. Here, you need to check the **“Transpose”** option and hit the **“OK”** button.

![Select Transpose](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Select-Transpose.png)<figcaption id="caption-attachment-21133">Select Transpose</figcaption>

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

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-33.png)<figcaption id="caption-attachment-21134">Result</figcaption>

## Transpose data using the TRANSPOSE function:

You can also use the [**TRANSPOSE function**](https://geekexcel.com/how-to-use-transpose-function-in-microsoft-excel-365/) to achieve the same result.

**=[TRANSPOSE](https://geekexcel.com/how-to-use-transpose-function-in-microsoft-excel-365/) (range)**

- First, you need to enter the input values.

![Select range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Select-range.png)<figcaption id="caption-attachment-21130">Input Values</figcaption>

- Then, you need to select the range where you want to display the result. Refer to the below example image.
- Here, we will select the range **D3:G3**.

![Select the cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Select-the-cells.png)<figcaption id="caption-attachment-21135">Select the cells</figcaption>

- Enter the given formula in the formula bar section.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-the-formula-14.png)<figcaption id="caption-attachment-21137">Enter the formula</figcaption>

- After that, Press **CTRL** + **SHIFT** + **ENTER**  Keys.
- Finally, you can get the result as per the below image.

![Result 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-1-2.png)<figcaption id="caption-attachment-21136">Result 1</figcaption>

## Closure:

In this short tutorial, we have described the simple and useful steps to **transpose the data** using the paste special option and **TRANSPOSE function** in Excel. I thank you for reading and hope to see you on our next blog!!

### Related Articles:

- **[Options in Quick Access Toolbar in Microsoft Excel 365](https://geekexcel.com/options-in-quick-access-toolbar-in-microsoft-excel-365/)**
- **[How to Print Multiple Ranges/Selections into One Page in Excel 365?](https://geekexcel.com/how-to-print-multiple-ranges-selections-into-one-page-in-excel-365/)**