How to Paste Columns as Rows in Excel with Transpose

How-to basics · Updated November 21, 2026

To paste columns as rows in Excel, copy the source cells, select the top-left cell of an empty destination, then choose Home > Paste > Transpose. Excel swaps the rows and columns in the copied range: for example, a five-cell column becomes a five-cell row. The source stays where it is, so you can compare the original and transposed data before deciding whether to remove anything.

What You’ll Need

  • An Excel workbook with the cells you want to rearrange. The steps below are for Excel for Microsoft 365 on Windows.
  • An empty destination area large enough for the transposed range. A source range with 3 columns and 4 rows needs space for 4 columns and 3 rows.
  • Edit access to the workbook. If the sheet is protected, you may need permission to paste into the destination.

You do not need a formula or add-in for a one-time transpose. The built-in Paste Special command is usually the quickest approach.

Step-by-Step

  1. Check the source range. Identify the complete rectangular block you want to turn. For example, if your data occupies A1:C4, it has 3 columns and 4 rows. When transposed, it will occupy 4 columns and 3 rows. Include the relevant headings if you want them rearranged along with the data. Avoid selecting entire worksheet columns unless you genuinely need every cell; a compact range is easier to paste and check.
  2. Copy the cells. Drag across the source range, or click its first cell and Shift-click its last cell. You can also click the first cell, hold Shift, and use the arrow keys to extend the selection. Press Ctrl+C on Windows. A moving dashed border around the selection indicates that Excel has copied it. Do not cut the source if you want to preserve the original while checking the result.
  3. Choose a safe destination. Click a blank cell where the upper-left corner of the result should go. Leave enough room to the right and below for the new dimensions. For a source of 3 columns by 4 rows, allow a 4-column-by-3-row destination. Make sure the destination does not overlap the source, other important data, or merged cells. If you are unsure, use a new worksheet: click the plus button beside the sheet tabs, then choose A1.
  4. Open the Paste menu. On the Windows ribbon, select Home, then click the arrow beside Paste in the Clipboard group. Find and select Transpose. Depending on the ribbon layout, Transpose may appear as an icon in the Paste Options area; hovering over an icon can show its name. You can also right-click the destination cell and select the Transpose paste option if it is shown.
  5. Use Paste Special if you want to choose what is copied. Select Home > Paste arrow > Paste Special to open the dialog. Choose All to include the copied content and formatting, or choose Values if you want the displayed results without formulas. Check Transpose, then click OK. This is useful when you want to rearrange values but do not want to bring over the source’s formulas or appearance. The exact options may look slightly different in other Excel builds, but the dialog includes a Transpose setting.
  6. Check the transposed result. Confirm that the first source row appears in the first destination column and that the final dimensions are correct. For example, a selected range of A1:C4 should fill four rows and three columns if placed at E1; the source’s four rows have become four destination columns, while its three columns have become three destination rows. Check labels, numbers, blanks, and formulas before relying on the result.
  7. Keep, edit, or remove the original. The paste creates a separate copy and leaves the source unchanged. If the transposed data is correct, you can keep both ranges, move the result, or delete the original. Save the workbook after checking it. If you delete the source, make sure that no formulas or charts elsewhere still depend on it.

On a Mac, use the same general process: select the range and press Command+C, choose the destination, then use Home > Paste and select Transpose. If you do not see that option, use Edit > Paste Special and look for the Transpose checkbox. The menu appearance can vary by Excel version. In Excel for the web, look for Transpose in the Paste options after copying; if it is unavailable in your interface, open the workbook in the desktop app to use the Paste Special dialog.

Common Mistakes

  • Pasting over existing cells: The transposed block can overwrite data in its destination. Excel may warn that cells contain information, but do not rely on a warning to protect important content. Choose a blank area or a new sheet, and check the destination dimensions first.
  • Selecting too little or too much: If you omit a heading, it will not appear in the result. If you accidentally include adjacent notes or blank rows, those cells are transposed too. Look at the selection outline before copying and verify the first and last cells.
  • Expecting blanks to disappear: Transpose preserves the shape and position of blank cells within the range. It does not compact a list or remove empty rows. If a source column contains gaps, the corresponding transposed row will contain gaps in those positions.
  • Assuming formulas become fixed values: The regular Transpose paste can carry formulas and other copied content. Excel may adjust relative cell references to suit the new location, so a formula can return a different result after pasting. Use Paste Special with Values selected when you want results rather than formulas.
  • Overlooking formatting: A standard transpose paste may bring over number formats, fills, borders, or other formatting. If the destination looks unexpected, undo immediately with Ctrl+Z on Windows, then repeat using Paste Special and choose the content type you need.
  • Copying inside the source: If the result overlaps the original range, Excel can block the operation or create a confusing layout. Paste to a separate blank area first. Once you have verified the result, you can move it to its final location if needed.

Tips

  • Use a new sheet for a clean comparison. Pasting the result into a separate worksheet keeps the original intact and makes it easy to compare corresponding labels or values. Rename the tabs clearly, such as Source and Transposed, so you know which version you are viewing.
  • Plan the destination using the swapped dimensions. Count the source rows and columns before pasting. The destination will have as many rows as the source had columns, and as many columns as the source had rows. This quick check helps prevent collisions with nearby data.
  • Choose Values when you need a static copy. If the source contains formulas but the transposed result should keep only the current displayed numbers or text, use Paste Special, select Values, and check Transpose. This separates the result from formula calculations in the source, though it will not update automatically if the source later changes.
  • Keep formulas when the result should stay connected. If formulas are useful in the new layout, use the normal transpose paste or choose a formula-based paste option. Then inspect formulas that refer to other cells. Relative references can change during a paste; absolute references using dollar signs stay fixed in the relevant row or column.
  • Preserve the original until you finish checking. A copied transpose is easy to compare and undo. Save a copy of the workbook before making larger structural changes, especially when other sheets may refer to the source range.
  • Use the clipboard carefully. Copy the source immediately before pasting. If you copy something else in between, Excel replaces the copied range on the clipboard. The dashed border around the original selection is a useful visual reminder that the copied cells are still active.

Troubleshooting

Transpose is missing from the Paste menu. First confirm that you copied a cell range in Excel, rather than text from another application or a file object. Click a destination cell and open the Paste dropdown again. If the ribbon option is still unavailable, use Home > Paste arrow > Paste Special and check for Transpose. On Mac, try Edit > Paste Special. If the workbook is open in a browser and the command is not available there, use the desktop version.

Excel says the destination range is not blank or will not paste. Cancel rather than clearing cells blindly. Select another empty area or add a worksheet, then paste there. Also check whether the destination contains merged cells, whether the sheet is protected, and whether the copied selection overlaps the destination. Unmerge cells only if doing so is appropriate for the worksheet layout.

The output is the wrong size or direction. Remember that transpose exchanges rows and columns; it does not simply move a column sideways unchanged. A single column containing five cells becomes one row containing five cells. If you meant to place each of several source columns as its own destination row, transpose the full multi-column range. Recheck the outline of the source selection and compare the result’s row and column counts.

The result has unexpected values or formulas. Select a result cell and inspect the formula bar. If you need a fixed snapshot, undo the paste and repeat with Paste Special, Values, and Transpose. If formulas are intended, compare their references with the source and confirm that changed relative references make sense. If a result appears blank, check whether the source cell was actually empty or contained a formula that returns an empty string.

The formatting looks wrong. Undo the paste, then reopen Paste Special and choose Values with Transpose to avoid copying the original formatting. If you need the data and the source formatting, choose All with Transpose and adjust the destination formatting afterward. Be especially careful with dates, percentages, and currency: a displayed value may look different if the destination uses a different number format.

Frequently Asked Questions

Can I paste one Excel column across a row?
Yes. Copy the cells in the column, select the first destination cell, and choose Transpose from the Paste menu. The column’s values will run horizontally across a row, in the same top-to-bottom order as the source.

Does transposing delete or change my original data?
No. Copying and transposing creates a separate result and leaves the source in place. The original changes only if you edit or delete it afterward, or if you choose a destination that overwrites existing cells.

Can I transpose without copying the formatting?
Yes. Open Paste Special, choose Values, and check Transpose. You can also choose another available paste type if you need formulas but not formats. Inspect the dialog choices in your version before confirming.

Will the transposed result update when the source changes?
A normal paste creates a separate pasted range, not a live link that automatically mirrors later edits. If you need a result that recalculates, use a formula-based approach such as the TRANSPOSE function, taking care to enter it in a suitable destination range for your Excel version.

Can I transpose a range that contains formulas?
Yes. A normal transpose paste can include formulas, and Excel may adjust relative references for their new positions. Review important formulas after pasting. To keep only their current displayed results, use Paste Special with Values and Transpose instead.

Why did blank cells remain in my transposed row?
Transpose keeps the relative positions of cells, including blanks inside the selected rectangle. It rearranges the range; it does not remove empty cells. Select only the cells you need, or separately clean the data if you want a compact list.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.