In this example, we want to transpose cells from A1 to B4. Now type the range of the cells you want to transpose.

Step 3: Type the range of the original cells. Notice that the eight cells are still selected even though we have started typing a formula. With those blank cells still selected, type: =TRANSPOSE( This is where the new, transposed cells will end up.

So, we need to select eight horizontal cells, like this: For example, there are 8 cells here that are arranged vertically: But make sure to select the same number of cells as the original set of cells, but in the other direction. Step 1: Select blank cellsįirst select some blank cells.

For more information on array formulas, see Guidelines and examples of array formulas. Excel inserts curly brackets at the beginning and end of the formula for you. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press Ctrl+Shift+Enter to confirm it. Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula.

Turn column into row excel