您是否曾经设置过电子表格，然后意识到不同的布局效果会更好？您可以在Google 表格(Google Sheets)中轻松地将行转换为列，反之亦然，以根据需要显示数据。
有两种切换行和列的方式，您可以使用最适合您的方式。这包括选择性粘贴(Paste Special)功能和移调(TRANSPOSE)功能。如果您已准备好开始，请参阅以下如何在Google 表格(Google Sheets)中使用转置的方法。
(Convert Rows)使用选择性粘贴(Paste Special)转换行和列(Columns)
转换行和列的一种快速方法是使用Google 表格(Google Sheets)中的“选择性粘贴”(Paste Special)功能。使用它，您只需复制数据，然后将其粘贴为转置即可。
使用此选项的好处是，如果您的单元格中有粗体文本或填充颜色等格式，则该格式将应用于粘贴的单元格。
- 首先选择要转置的数据。例如，我们将把城市列转换为行。
- 通过执行以下操作之一复制数据：
- 从菜单中选择编辑 > 复制。
- 右键单击并选择复制。
- 在Windows上使用键盘快捷键Ctrl + C，在Mac上使用Command + C C。
- 转到要粘贴数据的单元格，确保有足够的空间，以免覆盖现有数据。
- 选择Edit > Paste Special或右键单击并移至“选择性粘贴”(Paste Special)。然后，在弹出菜单中选择转置。
然后您应该会看到所选的单元格被粘贴。
如果您想在粘贴后删除原始数据，可以像删除工作表中的任何其他数据一样删除它。
(Convert Rows)使用TRANSPOSE 函数(TRANSPOSE Function)转换行和列(Columns)
如果您习惯使用Google 表格公式(Google Sheets formulas)，则可以使用TRANSPOSE函数和简单公式转换行或列。
请记住，与上面的“选择性粘贴”功能不同，当您使用(Paste Special)TRANSPOSE功能时，现有文本或单元格格式不适用。
该公式的语法是TRANSPOSE（范围），只需一个用于表示要切换的单元格范围的必需参数。
转到要转置数据的单元格，确保有足够的空间。然后，输入以下公式，用您自己的公式替换单元格范围：
=转置(A2:G3)
按 Enter(Press Enter)或Return 键(Return)，您应该会看到转置的数据。
同样，如果您愿意，可以在使用TRANSPOSE公式转换后删除原始数据集。
在移动设备上转换行和列
如果您在 Android 或 iOS 设备上(Google Sheets on your Android or iOS device)使用Google 表格，则也可以在其中转换行和列。虽然您可以在Android上使用选择性粘贴(Paste Special)功能或TRANSPOSE功能，但目前只能在 iPhone 上使用该功能。
Android 上的转置
要在Android(Android)上切换行或列，请打开Google 表格(Google Sheet)并按照以下简单步骤使用选择性粘贴(Paste Special)。
- 选择要转置的单元格。您可以使用右下角的蓝点拖动它们。然后，点击 显示工具栏并选择复制(Copy)。
- 转到您想要转换行或列的单元格，点击，然后在工具栏中选择选择性
粘贴。(Paste)
- 当“选择性粘贴”(Paste Special)选项出现时，选择“粘贴(Paste)转置”。
然后您将看到转换后的行或列。
如果您更喜欢在Android上使用TRANSPOSE功能，请按照以下步骤操作，因为它们在 iPhone 上是相同的。
在 iPhone 上移调
如前所述，截至撰写本文时，您无法使用 iPhone 上Google 表格中的(Google Sheets)“选择性粘贴(Paste Special)”功能。但是，您可以使用TRANSPOSE函数来切换行和列。
- 转到您想要转置单元格的单元格。
- 在底部的文本框中输入公式。
- 点击绿色复选标记以应用公式，您应该会看到转换后的行或列。
在Google 表格(Google Sheets)中，将行转换为列或将行转换为列很容易。如果您也使用Microsoft Office，也请看看如何在 Excel 中转置数据(how to transpose data in Excel)！
How to Transpose Rows and Columns in Google Sheets
Have there been timеs уou set up your spreadsheet and then realized that a differеnt layout would work better? Υou can easily convert rows to columns or vice versa in Google Sheets to display your data as you please.
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.
- Start by selecting the data you want to transpose. For example, we’ll convert our column of cities to a row.
- Copy the data by doing one of the following:
- Select Edit > Copy from the menu.
- Right-click and choose Copy.
- Use the keyboard shortcut Ctrl + C on Windows or Command + C on Mac.
- Go to the cell where you want to paste the data, making sure you have enough space so that you don’t overwrite existing data.
- Either select Edit > Paste Special or right-click and move to Paste Special. Then, pick Transposed in the pop-out menu.
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.
- Select the cells you want to transpose. You can drag through them using the blue dot on the bottom right corner. Then, tap to display the toolbar and choose Copy.
- Go to the cell where you want the converted rows or columns, tap, and select Paste special in the toolbar.
- When the Paste Special options appear, choose Paste transposed.
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.
- Go to the cell where you want the transposed cells.
- Type the formula into the text box at the bottom.
- Tap the green checkmark to apply the formula and you should see your converted rows or 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!
