TRANSPOSE Function
Process Flow to Use the TRANSPOSE Function in Excel
The TRANSPOSE function is used to switch (transpose) rows into columns and columns into rows.
📌 Steps to Use the TRANSPOSE Function
1️⃣ Enter Your Data
- Assume you have the following data in Range A1:C3:
| A | B | C |
|---|---|---|
| Name | Age | City |
| Alice | 25 | Delhi |
| Bob | 30 | Mumbai |
2️⃣ Select an Empty Area to Paste the Transposed Data
- If your data is in A1:C3, select an empty range where the transposed version will be displayed (e.g., E1:G3).
3️⃣ Apply the TRANSPOSE Function
- In Cell E1, enter:
- Press Ctrl + Shift + Enter (if using older Excel versions) or just Enter (for Excel 365 and 2019).
4️⃣ Result:
| E | F | G |
|---|---|---|
| Name | Alice | Bob |
| Age | 25 | 30 |
| City | Delhi | Mumbai |
🎯 Note: The transposed data is linked to the original data. If you change the values in A1:C3, the transposed data in E1:G3 will update automatically.
📌 Alternative: Using Paste Special for Static Data
If you want a non-dynamic transposed table, follow these steps:
- Select A1:C3 (your original data).
- Press Ctrl + C to copy.
- Click on an empty area (e.g., E1).
- Right-click and choose Paste Special → Select Transpose.
- Click OK → Your data will now be transposed but will not change if the original data updates.