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 number of …

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 versa.

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

After you switch rows to columns in the chart, the columns of data are plotted on the vertical axis, and the rows of data are plotted on the horizontal axis. However, you can quickly change the way that …

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 combinations.

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.

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

Cách sử dụng hàm TRANSPOSE trong Excel để chuyển đổi hoặc xoay ô.

De functie TRANSPONEREN in Excel gebruiken om cellen te schakelen of te draaien.