Forum Discussion
Sort years chronologically
Hi AlphaTau
In PowerQuery, you can sort by multiple columns and create an index based on that sort.
Try this in PowerQuery:
1. Select the Country column and sort accordingly
2. Right-click the next column (Year) and sort accordingly.
At the far right of the column headers next to the down arrow to select/sort, you should see a tiny "1" or "2" next to Country and Year respectively.
3. Add a new Index column.
4. After you are done in PowerQuery, the Index should be available to sort by.
I hope this helps.
Solution SageHi AlphaTau
In PowerQuery, you can sort by multiple columns and create an index based on that sort.
Try this in PowerQuery:
1. Select the Country column and sort accordingly
2. Right-click the next column (Year) and sort accordingly.
At the far right of the column headers next to the down arrow to select/sort, you should see a tiny "1" or "2" next to Country and Year respectively.
3. Add a new Index column.
4. After you are done in PowerQuery, the Index should be available to sort by.
I hope this helps.