How to Rotate Columns in Excel

When you have data pasted into an Excel spreadsheet, which is referred to as transposed data, it can be helpful to convert column data to rows data. This process is known as 'transposing' the data. In this article, we will explore how to rotate columns in Excel using both a manual method and a shortcut key.

Manual Method

To transpose your data manually, follow these steps:

1. Select all the cells that contain the dataset you want to convert.

2. Right-click on the selected cells and choose 'Paste Special' from the context menu.

3. In the Paste Special dialog box, select the 'Transpose' option.

4. Click OK to apply the changes.

Your dataset will now be converted into rows instead of columns. For example, if you had data in column C (C10 to C16), quantity sold in column D (D10 to D16) & total sales value in column E (E10 to E16), it would now appear as follows:

| Medicine Product Code | Quantity Sold | Total Sales Value |

| --- | --- | --- |

| 12345 | 100 | 5000 |

| 67890 | 200 | 8000 |

| 34567 | 50 | 2500 |

Shortcut Key

Alternatively, you can use a shortcut key to convert columns to rows in Excel. To do this:

1. Select the cell where you want to paste the transposed data.

2. Press Ctrl + C to copy the selected cells.

3. Right-click on the mouse and select 'Paste' from the context menu.

4. In the Paste Options dialog box, select the 'Transpose' option.

Your dataset will be copied into the selected cell range starting from cell G10 to M112, as shown in the screenshot below:

In this article, we have demonstrated how to rotate columns in Excel using both a manual method and a shortcut key. By following these steps, you can easily convert your column data to rows data, making it easier to work with and analyze your dataset.

Additionally, we have provided an example of converting a Pharma sales table from columns to rows, which can be downloaded here – . This template is just one example of how you can use the transpose feature in Excel. With this knowledge, you can apply it to other datasets and scenarios where transposing data is necessary.

Resources

* TEXT and String Functions in Excel (26+)

* Lookup and Reference Functions in Excel (35+)

* Excel Conditional Formatting Based on Another Cell Value

* SUMPRODUCT Function with Multiple Criteria

* Compare Two Columns in Excel for Matches

How to rotate columns in excel