Home » Posts

Flip table rows to columns

To flip a table in Excel from rows to columns (i.e. to change orientation from vertical to horizontal) you can use the TRANSPOSE function. In the example shown the formula in E5:K6 is: {=TRANSPOSE(B5:C11)} Note: this is a multi-cell array formula and must be entered with Control + Shift + Enter.

April 14, 2025 · 1 min · 58 words · Jacqueline Ali

The only requirement is that there be a one to one relationship between source and target cells.

Note that this function creates a dynamic link between the source and target.

Any change in to data in the source table will be reflected in the target table.

Excel formula: Transpose table without zeros

go for the source data, copy, then use Paste Special > Transpose.

Excel TRANSPOSE function