To flip a row into a column in Microsoft Excel for Microsoft 365 on Windows, copy the row, select the first destination cell, then choose Home > Paste > Transpose. If the column should update when the original row changes, enter a TRANSPOSE formula in the destination instead.
What flipping a row to a column means
Excel calls changing data from a horizontal layout to a vertical one transposing. For example, a row containing North, South, East, West, and Central becomes a column with those same entries from top to bottom. The order stays the same: the first item in the row becomes the first item in the column, and the last item stays last.
This is different from reversing a row. If you want Central, West, East, South, North, you want the values in reverse order, not merely in a column. Transpose changes the direction of a range without reversing its sequence. Check which result you mean before changing a large dataset.
Transposing can make a list easier to read, prepare data for a chart or report, or fit a worksheet layout. It changes the arrangement of cells, not the underlying meaning of the values. Dates remain dates and numbers remain numbers, although formatting and formulas may need a quick check afterward.
Use Paste Special for a quick, one-time change
Paste Special is usually the simplest choice when you need a snapshot of the row in a new direction. It copies the selected range into another location with rows and columns exchanged. The operation does not require a formula, and the result occupies ordinary cells you can edit independently.
- Select the row cells you want to turn into a column. You can select just the populated cells rather than the entire worksheet row.
- Copy them with Ctrl+C.
- Select the top cell where the new column should begin. Choose a blank area that has enough room below it.
- On the ribbon, select Home > Paste and choose Transpose from the paste options. Depending on the window and ribbon layout, Transpose may be shown as an icon; point to an option to see its label.
You can also right-click the destination and choose the Transpose paste option if it appears in the context menu. Another route is to open Home > Paste > Paste Special, select the Transpose checkbox, and confirm. The precise context-menu presentation can vary with the Excel build, but the transpose option performs the same orientation change.
For example, copying the five cells containing North, South, East, West, and Central and transposing them at G1 places North in G1, South in G2, East in G3, West in G4, and Central in G5. Leave the destination cells empty first; otherwise Excel may ask to replace existing data or prevent the paste.
Use the TRANSPOSE function for a live result
A formula is preferable when the output should reflect later edits to the source. In Excel for Microsoft 365, the function returns an array that spills into neighboring cells automatically. Enter it once in the first destination cell rather than filling it down one cell at a time.
With the source row in A1:E1 and an empty destination beginning at G1, enter =TRANSPOSE(A1:E1) in G1. The result fills G1:G5 in the same order as the source: North, South, East, West, and Central, assuming those are the values in A1:E1. When a source value changes, the corresponding spilled result updates.
Make sure every cell in the intended spill area is empty. If even one cell in G1:G5 contains data, Excel may show #SPILL! and leave the result unavailable. Clear the blocking cell or choose a different starting point. You can format the destination range, but do not type into an individual cell inside the spilled result; edit the source row or the formula instead.
The formula creates a dependent result, not a separate editable copy. If you need to send or edit the transposed values independently, copy the formula result and use a values-only paste in the destination. If the source is a row of formulas, decide whether you want those formulas to remain linked to their own precedents or want only their displayed results before converting them to values.
Choose the method that fits the job
The main decision is whether the output should stay connected to its source. Paste Transpose is convenient for a finished copy; TRANSPOSE is useful for a view that should keep pace with changes. Neither method is universally better.
- Choose Paste Transpose for a one-time rearrangement, a handoff, or a list you intend to edit separately.
- Choose TRANSPOSE when the row is maintained elsewhere and the column should update as its cells change.
- Choose a manual copy for a very short row if you need to review or reorder each item as you place it.
Paste Transpose normally transfers cell contents and formatting, but it does not create a live connection to the source cells. Constant values become copied values. If the source contains formulas, Excel pastes formulas as formulas and adjusts relative references as part of the copy operation; that is not the same as having each destination cell directly display its original source cell. Inspect formulas if their references matter.
A TRANSPOSE formula, by contrast, returns the current contents of the referenced range as an array. It is a good fit for dashboards or reporting areas where the source is authoritative. It is less suitable when people need to type different values into the output cells, because the output belongs to the formula’s spilled array.
Check formatting and worksheet layout
After pasting, check number formats, alignment, borders, and column width. Transpose can carry cell formatting, but a row’s height and a column’s width are different worksheet properties and should not be expected to map neatly onto each other. A long text item that fit across a wide row cell may be cut off in a narrow destination column. Widen the column or use Home > Format > AutoFit Column Width.
Dates and numbers may look different if the destination already has a number format. For instance, a copied date serial can display as a plain number if the receiving cells use a General format. Select the destination and apply an appropriate format from Home > Number. Confirm the underlying value in the formula bar if the display seems unexpected.
Also look for merged cells, hidden rows or columns, and existing content near the destination. Merged cells can make a rectangular paste range awkward or block a transpose operation. Unmerge or move the data first if Excel reports that the operation cannot be completed. When working on a shared or important workbook, use an unused area or a copy of the sheet so you can compare the result before replacing the original.
Transposing more than one row
The same operation works on a rectangular range, not just a single row. If you copy a range that is three rows tall and four columns wide, transposing it produces a range four rows tall and three columns wide. Each cell keeps its relative position with the row and column coordinates exchanged. This can be useful for turning a compact table sideways.
For a larger range, select the exact rectangle rather than an entire worksheet row or column. Check that the destination area has the matching dimensions and is clear. For a dynamic result, point TRANSPOSE at the whole rectangular source range; Excel spills a rectangle with its dimensions exchanged. The function does not decide which labels or totals should be omitted, so select only the data you want included.
Excel tables have their own structured layout rules. A spilled array formula cannot spill inside an Excel table, so put the TRANSPOSE formula in a blank worksheet area outside the table. For a one-time rearrangement, paste the result outside the table first, then decide whether to format the new range as a table using Home > Format as Table.
Common problems and how to fix them
- Transpose is missing or unavailable: Make sure you copied a range first and then selected a destination. If the clipboard no longer contains the copied cells, copy the source again. The Transpose option is a paste operation, so it is not available in the same way before copying.
- The paste will not fit: Clear the destination cells and check for merged cells. A transposed rectangle needs the same number of destination rows as the source has columns.
- The formula shows #SPILL!: Remove content, merged cells, or other obstructions in the intended spill area, then let Excel recalculate.
- The displayed values look wrong: Check number formats and formula references. A changed display may be a formatting issue rather than a changed underlying value.
- The output does not update: A pasted copy is not a live mirror. Use a TRANSPOSE formula if the output must respond to source edits, and check that calculation is not set to Manual under Formulas > Calculation Options.
One common misconception is that transpose reverses the contents. It does not: it changes rows into columns and columns into rows while retaining the order across the range. If you need a reversed sequence, use a separate reordering method rather than expecting the Transpose command to reverse it.
Excel for Mac and Excel for the web
In Excel for Mac, the same general Paste Special or Transpose approach is available, though ribbon placement and context-menu details can differ by version. The common copy and paste shortcuts are Command+C and Command+V, rather than Ctrl+C and Ctrl+V on Windows. Excel for the web also supports transposing copied data when its paste options offer Transpose; menu presentation can vary, so use the option label or icon shown after copying.
The TRANSPOSE function is also available in current Excel versions. In Microsoft 365 it returns a dynamic array, so enter the function in one cell and leave the spill range clear. Older desktop Excel versions may require selecting the full output range and confirming the formula as a legacy array formula. If instructions for an older version do not match your Microsoft 365 behavior, use the single-cell dynamic-array method described above.
Frequently Asked Questions
Can I flip a row to a column without changing the original?
Yes. Select a blank destination and use Paste Transpose, or place a TRANSPOSE formula elsewhere. Both leave the source row in place. The pasted result is independent for constant values, while the formula result stays connected to the source.
Does Excel have a keyboard shortcut for Transpose?
There is no single standard Ctrl-key shortcut that directly performs the Transpose paste in every Excel setup. On Windows, copy the range, use Ctrl+Alt+V to open Paste Special where supported, select Transpose, and confirm. Ribbon and context-menu options are clearer if the dialog differs in your build.
Will the transposed column update when I edit the row?
A Paste Transpose result does not automatically mirror later changes to constant source values. Use =TRANSPOSE(A1:E1) when A1:E1 is the source and you want a spilled result that updates. Keep the output cells clear so the array can spill.
Can I transpose a whole table?
You can transpose a selected rectangular range, but Excel does not simply turn every table feature into an equivalent sideways table. Select the data range you need, leave room for the exchanged dimensions, and check headers, totals, and formatting afterward. Place a dynamic-array formula outside an Excel table.
How do I reverse the order as well as make a column?
Transpose alone preserves the order. First arrange the values in reverse using a separate sorting or reordering step, then transpose them if needed. Keeping the two operations distinct makes it easier to verify that no item was skipped or moved unintentionally.
Related
- Master Excel Custom Number Formats: A Practical Guide
- Master List Excel Template: Create, Organize, and Use It
- Master Contact List Excel Template: Build and Manage It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Adding a Checkbox in Google Sheets: Steps and TipsTo add a checkbox in Google Sheets in a web browser, select the cell or range where you…
- Google Sheets GOOGLETRANSLATE Function: How It WorksGoogle Sheets includes a built-in GOOGLETRANSLATE function for translating text in a cell. For example, if A2 contains…
- Freeze Panes in Excel: Keep Rows and Columns VisibleTo keep headings or labels visible while you scroll in Excel, use View > Freeze Panes. Choose Freeze…
- Append Queries in Power Query: How to Combine TablesTo append queries in Power Query for Excel on Windows, open the Power Query Editor and choose Home…
- How to Remove a Section Break in Microsoft Word on MacTo remove a section break in Word on Mac, show formatting marks, click at the beginning of the…
- Freeze Just the Top Two Rows in Excel: A Quick GuideTo keep only the top two rows visible while you scroll in Excel for Microsoft 365 on Windows,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.