How to flip data in Excel

You can watch a video tutorial here.

There are times when analyzing data that columns would be better expressed when they are displayed horizontally. The TRANSPOSE command is useful to convert the alignment of the data.

Step 1 – Highlight an empty array of cells

Highlight an empty array of cells

Step 2 – Type in the TRANSPOSE command in the formula bar

When using the TRANSPOSE command always select the cells that you need to change the orientation.

Step 3 – Press CTRL + SHIFT + ENTER

By pressing CTRL + SHIFT + ENTER the formula will return an array.It is important to note that the output of the transpose function is dependent on the highlighted cells. Since in this example, there are only 7 cells that have been highlighted, then only the same number of the selected data has been shown.