Similarly, type in the references in the cells below as well.

For our purposes, that would be cell C4, which we’ll type in as RRC4.

In Cell B12, type in the same prefix ‘ RR’ and then the cell location to the right of the one we used in the previous step.

Type in a reference prefix, say ‘ RR’, and then the location of the first cell we want to transpose which is B4. We need a 6×6 empty cell area to transpose the data. In the above example, we have a 6×6 dataset in range B4:G9. We can switch rows and columns using cell references. Using Cell Reference to Switch Rows and Columns Read More: How to Transpose Multiple Columns to Rows in Excelģ.

If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula.

Whenever you change data in the original data, it will be reflected in the transposed data too.

The transposed data is still linked with the original data.

We need to select a 6×6 empty cell area to transpose the data. It means we have to predetermine how many rows and columns we’re gonna need and select that much area on the sheet. The TRANSPOSE functionis a multi-cell array formula. Use Transpose Function to Switch Rows and Columns Read More: How to Transpose Column to Multiple Rows in Excel (6 Methods)Ģ.

Right-click over the top-left cell of where you want to paste the transposed table, we choose Cell B11 in this case, then choose Transpose.

Select the range of cells B4:G9 and press Ctrl+C.

Follow the steps below to switch rows and columns. The new table will entirely overwrite any data/formatting that’s already there. Make sure that there is plenty of room to paste your data. Choose a location where you want to paste the transposed table.

Using the Paste Special feature is a quick way to switch rows and columns in Excel. Switch Rows and Columns by Paste Special (Transpose) Read the following article in detail and choose the best solution that matches your intent.ġ. We will use this dataset to demonstrate how to switch rows and columns in Excel. Let’s say you have the following dataset of the Market share of the smartphone companies. 5 Methods to Switch Rows and Columns in Excel

Change excel columns to rows