How to Transpose in Google Sheets: Rows to Columns

How-to basics · Updated November 20, 2026

To transpose data in Google Sheets, swap its rows and columns with the TRANSPOSE function for a result that updates with the source, or copy the range and use Edit > Paste special > Paste transposed for a one-time copy. Before either method, check that you have permission to edit the sheet and enough empty space for the result.

What You’ll Need

  • A Google Sheets spreadsheet open in a web browser, with editing access.
  • The rectangular range of cells you want to turn around, such as a table with several rows and columns.
  • An empty destination area large enough for the reversed layout. The number of source rows becomes the number of result columns, and the number of source columns becomes the number of result rows.

Step-by-Step

  1. Choose the method that fits your purpose. Use a formula if the transposed result should reflect future changes to the original data. Use Paste transposed if you need a separate copy to rearrange, share, or edit without depending on the source range. Both methods work in Google Sheets in a web browser.
  2. Check the source range and count its dimensions. Select or note the complete block, including any headers you want to carry over. For example, a range with two rows and three columns will become three rows and two columns. Avoid including unrelated cells, since they will be transposed too.
  3. For a live result, identify the source layout and choose an empty destination cell. Suppose the source data is in A1:C2: row 1 contains Item, Q1, and Q2, while row 2 contains mugs, 12, and 15. The transposed result needs three rows and two columns. Choose a clear destination such as E1, leaving E1:F3 empty.
  4. Enter the TRANSPOSE formula in the destination cell. With the example source range in A1:C2, enter this in E1:
    =TRANSPOSE(A1:C2)
    Press Enter. Google Sheets fills E1:F3 with Item and mugs in the first column, Q1 and 12 in the second, and Q2 and 15 in the third. You enter the formula only once; do not copy it into every result cell.
  5. Check that the output matches the intended orientation. Compare a few header-and-value pairs with the source. The first source row should become the first result column, and the first source column should become the first result row. If the result is in the wrong place, clear the destination output and put the formula in a better starting cell.
  6. For a one-time copy, copy the source range. Select the full range, then use Edit > Copy or Ctrl+C on Windows and ChromeOS. On a Mac, use Command+C. Select the top-left destination cell; make sure there is room for the rotated result and that you are not selecting a cell inside the original range.
  7. Paste the range transposed. Open Edit > Paste special > Paste transposed. Google Sheets inserts the copied range with rows and columns switched. Inspect the output before deleting or changing the original data. This operation does not create a live TRANSPOSE formula, so edits to the source will not automatically update the pasted copy.
  8. Decide whether you need to preserve a live connection. If you used Paste transposed but later want the result to track the source, undo the paste if practical and use the formula method instead. If the copied result is right but you need to replace formulas with their current displayed results, copy the pasted range and use Edit > Paste special > Values only. Check the result afterward, because values-only paste removes formulas.

Common Mistakes

  • Putting the formula in a range that is not empty. TRANSPOSE needs to fill an output rectangle. Existing content in any cell the result needs can block expansion or cause an error. Clear the required destination cells or move the formula to a blank area; do not erase data until you have confirmed it is safe to remove.
  • Expecting a pasted copy to update automatically. Paste transposed is useful for a snapshot, not a live link to the source. If new source entries should appear in the result, use the TRANSPOSE formula and ensure the selected source range includes the rows and columns you need.
  • Selecting only part of the table. Leaving out a header or including a neighboring note changes the shape and meaning of the result. Check the highlighted range before copying or writing the formula.
  • Typing the formula into every destination cell. In Google Sheets, enter one TRANSPOSE formula in the top-left output cell. The result expands from there. Filling the formula across a manually selected destination can create repeated or misplaced results.
  • Assuming formatting and layout will look identical. Transposing changes cell positions, but it does not necessarily produce the presentation you want. Check column widths, row heights, alignment, borders, and number formats after the operation.

Tips

  • Leave a buffer around a formula result. A clear block prevents the output from colliding with notes, other tables, or future entries. If the source may grow, reserve extra room and consider whether the formula’s source range should include additional blank rows or columns.
  • Keep headers with their data. Include the header row or column in the source range if those labels should move with the values. If you transpose only the data cells, the labels will stay behind and the new table may be difficult to interpret.
  • Use Paste transposed for a deliberate snapshot. It is convenient when you are preparing a report or reorganizing a table once. Use a formula instead when the source is a changing list, schedule, or tracker and you want the transposed view to recalculate from that source.
  • Protect the original before making major changes. If you plan to delete, sort, or replace source data, duplicate the sheet first using the sheet tab menu. A separate copy makes it easier to compare the original with the transposed result.
  • Review formulas and special cell content. If the source contains formulas, check a few transposed cells to see whether copied formulas still refer to the intended cells. Also inspect dates, currency, percentages, checkboxes, merged cells, and conditional formatting; these may need adjustments after the layout changes.
  • Know how Excel differs. In Excel for Microsoft 365, TRANSPOSE also returns a dynamic array, while desktop Excel offers a transpose option in its Paste Special controls. Menu names and placement differ from Google Sheets, so use Sheets’ Edit menu paths when following these instructions in a browser.

Troubleshooting

  • The formula reports an expansion or overwrite problem. Look across the entire expected output area, not just the top-left cell. Remove any obstructing values or formulas only if they are no longer needed, then re-enter the formula. Check for cells that look blank but contain a space or an invisible formula.
  • The result appears too small or misses newer entries. The formula only transposes the range you referenced. Edit its source range to include the missing rows or columns. If you selected a fixed range such as A1:C2, information added outside that range is not part of it automatically.
  • The rows and columns seem unchanged. Confirm that the source selection actually has different numbers of rows and columns, then compare its top-left and adjacent cells with the result. A square range can be transposed without changing its overall shape, though its cell order should still be reversed across the diagonal.
  • Paste transposed is unavailable or does nothing. First copy a cell range, then select a single destination cell and open Edit > Paste special. If the spreadsheet is view-only, request edit access. If browser clipboard permissions or another application interfere, try copying again from inside Sheets and use the menu rather than a keyboard paste shortcut.
  • The pasted result does not match the source after later edits. That is expected for a pasted snapshot. Recopy and paste the range again to refresh it, or replace the snapshot with a TRANSPOSE formula if it needs to stay connected. If formulas were in the source, inspect the pasted formulas individually before relying on them.
  • The formatting looks wrong. Adjust the destination column widths and row heights, then apply the number formats and alignment you need. If you only want to change the orientation of the data, use the transposed paste command rather than trying to rebuild the table by dragging cells one at a time.

Frequently Asked Questions

Does TRANSPOSE update when I change the original cells?
Yes. A TRANSPOSE formula recalculates from its referenced range when the source changes. A pasted transposed copy is not a live link, so you must paste it again to refresh it.

Can I transpose a single row into a column?
Yes. Select the row as the source range and use TRANSPOSE or Paste transposed. Its cells will appear vertically in the output. A single column works the other way, becoming a row.

Can I transpose only part of a spreadsheet?
Yes. Specify or select just the rectangular range you need. Include any labels that should move with the selected data, and leave out notes or neighboring cells that should remain where they are.

Will transposing change or delete my original data?
No. The formula displays its result elsewhere, and Paste transposed places a copy in the destination. Neither method requires you to remove the source. Check the destination before making separate edits or deletions.

Can I transpose data back to its original orientation?
Yes. Apply TRANSPOSE to the transposed range, or copy it and use Paste transposed again. Because the operation swaps rows and columns, doing it twice restores the original orientation, provided you use the complete result range.

Does this work in Excel too?
The TRANSPOSE function and transpose-paste feature also exist in Excel, but the menus are different. These steps use Google Sheets in a web browser; in Excel, use the Excel ribbon or Paste Special controls rather than the Google Sheets Edit menu.

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.