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.

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

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

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

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

Comment utiliser la fonction TRANSPOSE dans Excel pour basculer ou faire pivoter des cellules.

Comment utiliser Transpose dans Excel pour faire pivoter des colonnes et des lignes afin de réorganiser les données de votre feuille de calcul.

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.