How to Move Easy Rows and Columns in Google Sheets.Have you ever customized a spreadsheet and then realized that a different layout would work better? You can easily convert rows to columns or vice versa in Google Sheets to display data however you like.With two ways to switch rows and columns, you can use the one you are most comfortable with. This includes the special insert function 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 to use the special paste 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 fill color in your cells, that formatting is applied to the pasted cells.
- Start by selecting the data you want to transpose. For example, let’s convert our city column to a string.
- Copy the data by doing one of the following:
- Select Edit< / span> > Copy from the menu.
- Right click and select Copy.
- Use the keyboard shortcut Ctrl + C on Windows or Command + C > on a Mac.
- Go to the cell where you want to paste the data and make sure you have enough space so you don’t overwrite the existing data.
- Either select Edit > Paste Special or right click mouse and navigate to Paste Special. Then select Transposed from the popup menu.
You should then see your selected cells pasted. 
If you want to delete the original data after pasting it, you can delete it just like any other data in your worksheet.
Convert Rows and Columns With the TRANSPOSE Function
If you are used 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 described above, the formatting of existing text or cells is not applied when using the TRANSPOSE function.The formula syntax is: TRANSPOSE(range) with one required argument for the cell range you want to switch.Navigate to the cell you want to move the data to, making sure you have enough space. Then enter the following formula, replacing the range of cells with your own:=TRANSPOSE(A2:G3) 
Press Enter or Return and you should see the transposed data. 
Again, you delete the original dataset after you use the TRANSPOSE formula to transform it, if you like.
Convert Rows and Columns on Mobile
If you are working with Google Sheets on your Android or iOS device, you can also convert rows and columns there. While you can use the special paste feature or the TRANSPOSE feature on Android, you can only use this feature on iPhone at this time.
Transpose on Android
To switch rows or columns on Android, open Google Sheets and follow these simple steps to use Paste Special.
- Select the cells you want to transpose. You can drag and drop them using the blue dot in the bottom right corner. Then click to display the toolbar and select Copy.
- Go to the cell you want to convert rows or columns to, tap and select Paste Special from the toolbar.
- When the Paste Special options appear, select Paste Transposed.
You will then see the converted rows or columns. 
If you prefer to use the TRANSPOSE feature on Android, follow the steps below as they are the same on iPhone.
Transpose on iPhone
As mentioned, at the time of this writing, you cannot use the special paste feature in Google Sheets on iPhone. However, you can use the TRANSPOSE function to switch rows and columns.
- Go to the cell you want to move the cells to.
- Enter the formula in the text box below.
- Click on the green tick to apply the formula and you should see the converted rows or columns.
Converting rows to columns or vice versa is easy to do in Google Sheets. If you also use Microsoft Office, learn how to transpose data in Excel too!
How to Move Rows and Columns in Google Sheets
How to Move Rows and Columns in Google Sheets