How to Turn Row to Column and Back (TRANSPOSE) in Excel + Video in Khmer

Hello everyone! Today I show you how to turn row to column and back in Excel step by step. This is very useful for anyone who work with data in Excel.

You ever receive data that go across row, but you want it to go down column? Or maybe data go down column but you want it across row? This is call Transpose — flip your data direction. I show you two way to do it — one without formula (easy!) and one with formula (powerful!). Video below is in Khmer so you can follow along easy.

1. How to Turn Row to Column Without Formula (Copy & Paste Special)

This is the most easy way! No formula need at all. You just copy your data and paste in special way. Good for anyone, even beginner.

Step by step:

1. Select your data — select the row or column you want to flip
2. Copy it — press Ctrl + C
3. Click empty cell — choose where you want paste the result
4. Right click → choose Paste Special
5. Check the box "Transpose" → click OK

Boom! Your data is now flip! Row become column, column become row.

Or faster way:

1. Copy your data (Ctrl + C)
2. Right click on empty cell
3. Look for Paste Options icon that look like two arrow flip
4. Click it — done!

💡 Tip: This copy-paste transpose method is available on all Excel version — even very old Excel. But remember, the result is not dynamic — if your original data change, the transposed copy will NOT update automatic. You need to redo it manually.

2. How to Turn Row to Column With Formula — TRANSPOSE Function

TRANSPOSE function flip your data dynamic — when original data change, transposed result update automatic too! This is more powerful than copy-paste method.

Syntax:

=TRANSPOSE(array)

• array — Required. The range you want to flip. Example: A1:E3

Example:

You have monthly sales data in row 1 (A1:F1) — January to June across column A to F. You want flip it so the month go down column instead.

Old Excel (before 365) — must press Ctrl+Shift+Enter:

1. First, select the destination range. If your original data have 1 row and 6 column, select 6 row and 1 column for destination.
2. Type: =TRANSPOSE(A1:F1)
3. Press Ctrl + Shift + Enter (not just Enter!) to enter as array formula.

Excel 365 or Excel 2021 — just press Enter:

=TRANSPOSE(A1:F1)

Just press Enter — Excel 365 handle the array automatic. Much easier!

👉 Result: Your data that was across 6 column now go down 6 row. And if you change value in A1:F1, the transposed result update automatic!

💡 Tip: In Excel 365, you can also use =VSTACK() or =HSTACK() to arrange data in different direction. But TRANSPOSE is the most direct way to flip row and column.

3. Video Tutorial in Khmer

4. Copy-Paste Transpose vs TRANSPOSE Formula — What is Difference?

Simple rule:

• Use Copy & Paste Transpose when your data will not change and you just want flip one time
• Use TRANSPOSE formula when your data change often and you want result to update automatic

💡 Quick Tips

1. Check your range size: When use TRANSPOSE formula in old Excel, you must select destination range with correct size first — if original is 3 row × 5 column, destination must be 5 row × 3 column.
2. Excel 365 make it easy: In Excel 365, just type =TRANSPOSE(range) and press Enter. No need select destination first, no need Ctrl+Shift+Enter. Excel handle everything!
3. Cannot edit transposed array in old Excel: If you enter TRANSPOSE with Ctrl+Shift+Enter, you cannot edit individual cell inside the result. You must delete all and redo.
4. Combine with other formula: TRANSPOSE work well inside other formula. Example: =SUM(TRANSPOSE(A1:A10)) — transpose first then sum. Useful in advance formula scenario.

📚 Useful Resources

• ROW vs ROWS Function in Excel Explained
• COLUMN vs COLUMNS Function in Excel Explained
• VSTACK vs HSTACK Function in Excel Explained
• TAKE vs FILTER Function in Excel Explained
• Top Microsoft Excel Tips and Tricks Every Spreadsheet User Should Know
• Free Download PDF - 50 Popular Excel Formulas Cheatsheet (Khmer Language)