How to Convert Rows to Columns in Google Sheets

Change your spreadsheet layout quickly and easily with the transpose feature. Here’s how to convert rows to columns in Google Sheets.

When you’re creating a spreadsheet, sometimes you realize that the data would be better formatted differently. And while it’s nice to know this before you start entering your data, it doesn’t always happen that way.

You may set up several columns only to discover; they would be better suited as rows or vice versa. Just like the transpose feature in Microsoft Excel, Google Sheets gives you the same option. This lets you easily convert rows to columns or the opposite.

Convert Rows and Columns in Google Sheets

You’ll use the same process in Google Sheets to convert rows to columns as columns to rows. So, sign in to Sheets, open your workbook, and pick the sheet you want to use.

  1. Select the cells you want to transpose. You can do this easily by selecting the first cell and then dragging through the rest.
  2. Either right-click and choose Copy or click Edit > Copy from the menu.
  3. Select the cell where you want to place the converted data.
  4. Either right-click or click Edit from the menu. Choose Paste special > Paste transposed.

Paste Special, Paste Transposed

You should then see your data flipped to the new layout. For this how-to, we converted rows to columns, as seen in the screenshot below.

Transposed rows to columns in Google Sheets

Remove the Original Data

Now that you’ve converted your rows to columns or vice versa, you still have the original data in place. So even if you use the Cut action instead of Copy in Step 2 above, that data remains. But you can easily remove it by deleting the data in the cells or removing those columns.

  • Select the cells containing the original data and hit your Delete key.
  • Select the columns by dragging through them. Either right-click or click the arrow next to a column header and pick Delete columns X – X.

Delete columns in Google Sheets

Depending on where you pasted the transposed data, you may also be able to remove rows. Just be sure your converted data isn’t affected.

  • Select the rows by dragging through them, right-click, and pick Delete rows X – X.

Delete rows in Google Sheets

Tip: If you accidentally delete data, hit the Undo button on the left side of the toolbar. You can click the button continuously to undo each last action in order.

Make Your Google Sheets Layout Work For You

You don’t have to be stuck with the layout you select when you first create your spreadsheet. With helpful features like transpose, you can easily convert rows and columns for the best way to display and work with your data.

For related topics when working on your spreadsheets, take a look at how to freeze, hide, or group columns and rows or how to get column statistics in Google Sheets.

Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *


To Top