How to Geometrically Flip an Excel Table

Published on 30 Jan, 2019 by Milos Gregor


From graphical programs, we know the function of horizontal and vertical flipping. Similar functionality can also be useful for tables with data. This post introduces Flip_Horizontal and Flip_Vertical functions that you can use within the Reshape.XL add-in.

Sometimes it happens that a table of data is required to view horizontally or vertically rewound  -  the first columns will be displayed at the end and the last columns will be at the beginning of the table. We can not do this easily and quickly with the basic functionality of Excel. For this, we can use the Reshape.XL add-in features  -  Flip_Horizontal and  Flip_Vertical.

Flip_Horizontal
Flip_Vertical

The character of the described functions is obvious form their names. Functions show the table in a rotated order. Using the Flip_Horizontal function, you change the columns order. Flip_Vertical, on the other hand, changes the display of the table rows  -  the first records are displayed at the end of the table and the last records will be displayed first. A practical example of their use is displayed in the following video-tutorial.

Table flipping is very fast and simple. Complete documentation for these features can be found at the following links: