Free tools Windows power users keep installed
One-click scans. No signup required.
Some links on this page are affiliate links: if you buy through them we may earn a commission, at no extra cost to you.
To turn a row into a column in Excel, copy the horizontal range, select an empty destination cell, then choose Home → Paste → Transpose. This creates a static copy. If you want the vertical results to update when the source changes, use the TRANSPOSE formula instead.
Transpose a row into a column with Paste
In Excel, arranging data left to right across columns is horizontal; arranging it top to bottom down rows is vertical. Transpose swaps rows and columns. For example, values in A1:F1 become values in six cells down a column.
- Select the source range, such as
A1:F1. - Copy it: press Ctrl+C on Windows or Control+C on Mac.
- Click the first cell of a blank destination area, such as
A3. - Choose Home → Paste → Transpose. You can also right-click the destination and choose the Transpose paste option.
The example range A1:F1 will fill A3:A8. Use Copy, not Cut, and choose a destination that does not overlap the source. Leave enough empty space: pasted results may overwrite existing content or formatting. The original remains in place; delete it only after checking the result if you no longer need it.
The ribbon wording or location can vary slightly in Excel for the web and on Mac, but look for Transpose in the Paste options. Microsoft documents the feature for current desktop editions, Excel for the web, and supported Mac editions. See Microsoft’s transpose instructions and Mac instructions.
Choose between a one-time copy and a linked result
| Your goal | Use | What happens |
|---|---|---|
| Convert the data once | Paste → Transpose | Creates a separate, static copy. |
| Keep the vertical output in sync with the source | =TRANSPOSE(range) |
Returns a formula-linked result that updates when the source changes. |
| Repeat the same reshaping on refreshed imported data | Power Query | Provides a repeatable data-shaping workflow. |
| Rearrange a report for analysis | PivotTable | Changes a report’s layout and can summarize data; it does not simply rotate the original cells. |
For a one-off row-to-column conversion, Paste Transpose is usually quickest. For recurring imports or analysis, Power Query or a PivotTable may be more suitable; they involve more setup than a basic transpose.
Transpose with the TRANSPOSE formula
Enter this formula in the top-left cell of an empty output area:
=TRANSPOSE(A1:F1)In current Excel versions with dynamic arrays, press Enter. Excel spills the six results down into the cells below. Those cells must be clear; if another value blocks the output, Excel reports a spill error. The result stays linked to the source rather than becoming an independent copy.
PC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteFor a rectangular range, the output dimensions switch too. For example, a source with three rows and four columns, such as A1:D3, produces four rows and three columns:
Rank #3
=TRANSPOSE(A1:D3)In older Excel versions that use legacy array formulas, first select the full destination range with the reversed dimensions, enter the formula, then press Ctrl+Shift+Enter rather than Enter. Microsoft’s TRANSPOSE function documentation explains supported versions and entry behavior.
Choose what to paste: values, formulas, and formatting
Transpose rotates copied content, but the result can include different attributes depending on the paste option you choose. If you need values rather than formulas, use a values-oriented Paste Special option with Transpose. If the formulas should remain formulas, use a formula paste option. Windows users can open the Paste Special dialog with Ctrl+Alt+V; the exact controls vary by platform. See Microsoft’s Paste options guide.
Do not assume every part of the original layout will carry over exactly. After pasting, check number formats, column widths, conditional formatting, data validation, and merged cells. Merged cells can make a paste behave unexpectedly, so unmerge them or test on a duplicate first if the layout is complex.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →Formulas may need attention after transposing
When formulas are copied into a new orientation, references can adjust according to their relative or absolute settings. For example, A1 is a relative reference and may shift when copied; $A$1 is absolute and stays fixed. Mixed references such as $A1 or A$1 lock only the column or row. Check formula results after transposing rather than assuming they still express the same logic. Microsoft recommends reviewing formulas and using absolute references where appropriate.
Excel Tables: why Transpose may be unavailable
Excel’s standard Transpose paste option is unavailable when the source is an Excel Table. You can use TRANSPOSE() for a linked output, or convert the Table to a normal range before copying and transposing: select the Table, open the Table tab, then choose Convert to Range. Converting removes Table features such as structured references and automatic expansion, so make a copy first if the Table is used elsewhere. For a recurring transformation of imported data, consider Power Query.
Troubleshooting
| Problem | Likely cause | What to do |
|---|---|---|
| Transpose is missing | The source is an Excel Table, or the wrong paste controls are open. | Convert the Table to a range or use TRANSPOSE(); otherwise look in the Paste menu. |
| Paste does not work | You used Cut, or the source and destination overlap. | Copy with Ctrl+C or Control+C and choose a separate destination. |
| Existing cells change | The destination area contains data or formatting. | Undo if needed, then paste into a blank area or a new worksheet. |
| Formula output does not update | You used Paste Transpose, which makes a copy. | Use =TRANSPOSE(range) for a linked result. |
| The formula result is blocked | Cells in the dynamic-array spill area are occupied. | Clear the required output area or move the formula to a blank location. |
| Formulas return unexpected results | Relative references may have shifted. | Review the references and adjust them; use absolute or mixed references where appropriate. |
| Blank rows appear in the output | The source contains blank cells. | Basic transpose preserves blank positions. Remove blanks separately only if they are not meaningful. |
| A single cell contains comma-separated items | The items are text in one cell, not a horizontal range. | Split the text into cells first, then transpose the resulting range. |
If all the data is in one cell
A cell containing Apple, Banana, Cherry is not yet a horizontal range. Split it into separate cells first, then transpose those cells. In desktop Excel, you can use Data → Text to Columns. In applicable newer Excel versions, a formula can split and rotate the text in one step:
=TRANSPOSE(TEXTSPLIT(A1,", "))This formula assumes the items are separated by a comma followed by a space. The delimiter must match the text in your cell. Microsoft explains options for splitting cell contents.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
When to use Power Query or a PivotTable
Use Power Query (also called Get & Transform) when you repeatedly import or refresh data and need the same shaping steps each time. It is more repeatable than manual copy-and-paste, but unnecessary overhead for a small one-time conversion.
Use a PivotTable when the goal is to view or summarize a report from another perspective. You can move fields between Rows and Columns in the PivotTable Field List. A PivotTable reorganizes analysis; Transpose physically swaps the positions of cells. For broader guidance, see Microsoft’s Power Query help.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
