If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.

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 …

If you have a worksheet with data in columns that you want to rotate so it’s rearranged in rows, you can use the Transpose feature. It lets you rotate the data from columns to rows, or vice …

TRANSPOSE 函数可返回转置单元格区域，即将行单元格区域转置成列单元格区域，反之亦然。 TRANSPOSE 函数必须在与源单元格范围具有相同行数和列数的单元格区域中作为数组公式分 …

If a chart that you create does not display the worksheet data on the axis that you want, you can quickly change the way that data is plotted. For example, if rows of data are displayed on the …

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

Fungsi TRANSPOSE mengembalikan rentang sel vertikal sebagai rentang horizontal, atau sebaliknya. Fungsi TRANSPOSE harus dimasukkan sebagai rumus array dalam rentang yang …

Or maybe you want to transpose the pasted data from rows to columns. Or you might need to paste the result of a formula instead of the formula itself. Important: When you copy and paste …

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

You can use a worksheet formula to covert data that spans multiple rows and columns to a database format (columnar).