With two ways to switch your rows and columns, you can use whichever is most comfortable for you. This includes the Paste Special feature and the TRANSPOSE function. If you’re ready to go, here’s how to use transpose in Google Sheets.
Convert Rows and Columns With Paste Special
A quick way to convert rows and columns is using the Paste Special feature in Google Sheets. With it, you simply copy the data and then paste it as transposed. The nice thing about using this option is that if you have formatting like bold text or a fill color in your cells, that formatting applies to the pasted cells.
Select Edit > Copy from the menu. Right-click and choose Copy. Use the keyboard shortcut Ctrl + C on Windows or Command + C on Mac.
You should then see your selected cells pasted. If you want to remove the original data after you paste it, you can delete it like any other data in your sheet.
Convert Rows and Columns With the TRANSPOSE Function
If you’re accustomed to using Google Sheets formulas, you can convert your rows or columns using the TRANSPOSE function and a simple formula. Keep in mind that unlike the Paste Special feature above, existing text or cell formatting does not apply when you use the TRANSPOSE function. The syntax for the formula is TRANSPOSE(range) with just one required argument for the range of cells you want to switch. Go to the cell where you want the data transposed, making sure you have adequate space. Then, enter the following formula replacing the cell range with your own: =TRANSPOSE(A2:G3) Press Enter or Return and you should see your transposed data. Again, you delete the original dataset after you use the TRANSPOSE formula to convert it if you like.
Convert Rows and Columns on Mobile
If you’re working with Google Sheets on your Android or iOS device, you can convert rows and columns there as well. While you can use the Paste Special feature or the TRANSPOSE function on Android, you can currently only use the function on iPhone.
Transpose on Android
To switch rows or columns on Android, open your Google Sheet and follow these simple steps to use Paste Special. You’ll then see your converted rows or columns. If you prefer to use the TRANSPOSE function on Android, follow the steps below as they are the same on iPhone.
Transpose on iPhone
As mentioned, you cannot use the Paste Special feature in Google Sheets on iPhone as of this writing. You can, however, use the TRANSPOSE function to switch your rows and columns. Converting rows to columns or the other way around is easy to do in Google Sheets. If you also use Microsoft Office, look at how to transpose data in Excel too!
