如何在Excel中轻松将行转换为列

You’ve set up a worksheet, when you realize it would look better if the rows and columns were reversed. There’s no need to re-enter all that data. Just use Excel’s Transpose feature.

您已经建立了一个工作表，当您意识到将行和列颠倒后看起来会更好。 无需重新输入所有数据。 只需使用Excel的转置功能。

Select the cells containing the headings and data you want to transpose.

选择包含要转置的标题和数据的单元格。

Click the “Copy” button or press Ctrl+C to copy the selected cells.

单击“复制”按钮或按Ctrl + C复制所选的单元格。

Click a blank cell where you want to copy the transposed data. The cell you select becomes the top, left corner of whatever you’re copying.

单击要复制转置数据的空白单元格。 您选择的单元格将成为您要复制的内容的左上角。

Click the down arrow under the “Paste” button, and then click the “Transpose” button on the dropdown menu.

单击“粘贴”按钮下的向下箭头，然后单击下拉菜单上的“移调”按钮。

Just like that, your rows become columns and your columns become rows—complete with any formatting you’d already applied to the original selection.

就像这样，您的行变成了列，而您的列变成了行-完成所有已经应用于原始选择的格式。

Note that your original, pre-transposed data still exists. You can select those cells again, and delete them if you want.

请注意，原始的，预先转置的数据仍然存在。 您可以再次选择这些单元格，然后根据需要将其删除。

It’s a quick trick, but it sure is a lot quicker and easier than retyping all your data and formatting those rows again.

这是一个快速的技巧，但是与重新键入所有数据并再次格式化这些行相比，它肯定会更快，更轻松。

翻译自: https://www.howtogeek.com/howto/12366/convert-a-row-to-a-column-in-excel-the-easy-way/