Revert to original sort order? Add an index column in PowerQuery

00:00 Add an index column to keep track of sort order
00:27 Import the sorted order table into Power Query
00:38 Add a index column starting from 0, 1, or custom number
01:02 Enables you to get back to the original sort order in Power Query

Revert to original sort order in Excel's Power Query using the Add Index column. How to add a column in PowerQuery that creates an index (from zero, one or any other number). Can be useful when you know that there is lots of cleaning required of the data, but at the end you want to be able to sort it in the original sort order.