If we want to change the orientation of a table, that is to change the rows to columns, we can use the **TRANSPOSE function.** This post provides a clear guide on how you can flip the orientation of an excel table.

*Figure 1: How to flip table rows to columns in excel*

**General syntax of the formula**

**{=TRANSPOSE(range)}**

Where;

Range- refers to the range of values that you want to flip.

**How the formula works**

- TRANSPOSE function is fundamental when it comes to changing the orientation of an excel table.
- When working with this function to get the transpose, there must be a one on one relationship between the source and the target.
- Note that in our example above, we have transformed a table, which is six rows and two columns, to one of six columns and two rows.
- The TRANSPOSE function creates a dynamic link between the source and target. This ensures that any change in the source table is also reflected in the target table.
- This function is fundamental when dealing with very large sets of data.
- It also helps in reducing the cost of doing this, as it oversimplifies work.
- Note that this is an array formula, thus it is necessary that it be entered in an array format. i.e.
**Control + Shift + Enter.**

**Instant Connection to an Expert through our Excelchat Service**

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

## Leave a Comment