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:

  excel
  =TRANSPOSE(A1:C3)
  

• 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:

1. Select A1:C3 (your original data).
2. Press Ctrl + C to copy.
3. Click on an empty area (e.g., E1).
4. Right-click and choose Paste Special → Select Transpose.
5. Click OK → Your data will now be transposed but will not change if the original data updates.