Your new table will contain the same number of cells but will be rotated from the horizontal orientation to vertical or vice versa. Select the same number of cells, but change the orientation Keeping these figures in mind, proceed to the next step.Ģ. Our source table has 4 columns and 5 rows.

In this example, we are going to transpose the table that shows the volume of fresh fruit exports by county: You will need these numbers in the next step. Count the number of columns and rows in the original tableįor starters, find out how many columns and rows your source table contains. If you don't have much experience with Excel formulas in general and array formulas in particular, please make sure you follow the below steps closely. A trickier part is to enter it correctly in a worksheet. The syntax of TRANSPOSE leaves no room for mistakes when building a formula. How to use the TRANSPOSE function in Excel In Excel 2021 and Excel 365 that support arrays natively, it can be entered as a regular formula. Important note! For the TRANSPOSE function to work in Excel 2019 and lower, you must enter it as an array formula by pressing Ctrl + Shift + Enter.

Turn column into row excel