Reverse rows

With Power Query, it's possible to reverse the order of rows in a table.

Imagine a table with two columns, ID and Country, as shown in the following image.

Initial table with ID and Country columns. The ID rows contain, from top to bottom, values of 1 through 7. The Country rows contain, from top to bottom, USA, Canada, Mexico, China, Spain, Panama, and Columbia.

On the Transform tab, select Reverse rows.

The result of this operation will look as follows.

Output table with the rows reversed. The ID rows now contain, from top to bottom, values of 7 down to 1. The Country rows contain, from top to bottom, Columbia, Panama, Spain, China, Mexico, Canada, and USA.