How to use Transpose in Excel to rotate columns and rows to rearrange your worksheet data.

The TRANSPOSE function returns a vertical range of cells as a horizontal range, or vice versa. The TRANSPOSE function must be entered as an array formula in a range that has the same …

You can convert the table to a range first by using the Convert to Range button on the Table tab, or you can use the TRANSPOSE function to rotate the rows and columns.

This topic covers the common scenarios of the #VALUE! error when working in the TRANSPOSE function.

When you create a chart, Microsoft Office Excel determines the axis on which the data series are plotted, based on the number of worksheet rows and columns that are included in the chart, …

TRANSPOSE 函數時必須以範圍陣列公式的方式輸入，該範圍的列數和欄數必須分別等於來源範圍的欄數和列數。 您可以使用 TRANSPOSE 來變換陣列或工作表上之範圍的垂直和水平方向。

TRANSPOSE 函数必须在与源单元格范围具有相同行数和列数的单元格区域中作为数组公式分别输入。 使用 TRANSPOSE 可以转置数组或工作表上单元格区域的垂直和水平方向。

Spilled array formulas aren't supported in Excel tables. Try moving your formula out of the table, or converting the table to a range (select Table Design > Tools > Convert to range).

When you copy in Excel for the web, you can pick paste options in the destination cells. Select Home, select the clipboard icon, select Paste, and pick the specific paste option you want.

In Excel for Mac version 16.33 or higher, the "paste formatting", "paste formulas", and "paste values" actions can be added to your quick-access toolbar (QAT) or assigned to custom key …