电子表格转换为文档_将行转换为Google文档电子表格中的列（或向后）

电子表格转换为文档

If you have to deal with a lot of spreadsheets, you’re probably really bored right now. You also might be wondering how to turn a row into a column, or a column into a row. Here’s how to do it with Google Docs Spreadsheets.

如果您必须处理大量电子表格，那么您现在可能真的很无聊。 您可能还想知道如何将一行变成一列，或将一列变成一行。 使用Google文档电子表格的方法如下。

If you’re an Excel user, you’re also in luck, because we’ve already shown you how to turn a row into a column, or vice-versa. It won’t make you any less bored though.

如果您是Excel用户，那么您也很幸运，因为我们已经向您展示了如何将行变成列，反之亦然 。 但这不会使您感到无聊。

Convert a Row to a Column (or backwards)

将行转换为列(或向后)

The first thing you’ll need is a column or a row of information that you want to convert into the opposite. For our example, we’ve got this set of data that we created by using the Auto Fill options in Google Docs.

您需要做的第一件事是要将一栏或一排信息转换成相反的信息。 对于我们的示例，我们具有使用Google Docs中的“自动填充”选项创建的一组数据。

Now in another cell, you’ll need to use the TRANSPOSE function, which you can use by simply typing in the following:

现在在另一个单元格中，您需要使用TRANSPOSE函数，只需键入以下内容即可使用：

=TRANSPOSE(

=翻译(

And then selecting the cells with the mouse, or manually typing in the range of cells you want to copy. The final function in this example was:

然后使用鼠标选择单元格，或手动输入要复制的单元格范围。 此示例中的最终功能是：

=TRANSPOSE(A1:A11)

= TRANSPOSE(A1：A11)

Finish it off with the final ) character to complete the function, hit the Enter key, and there we are… the column was transposed over to the right.

用最后一个)字符将其结束，以完成该功能，按Enter键，然后就可以了……该列已移至右侧。

You can use the same thing to turn columns into rows, or rows into columns—just change the range you are looking for.

您可以使用同一件事将列变成行，或将行变成列，只需更改所需的范围即可。

翻译自: https://www.howtogeek.com/howto/15810/convert-a-row-to-a-column-or-backwards-in-google-docs-spreadsheets/

电子表格转换为文档