Numbering Groups or Categories of Data Records

If you had data in a group or category, you might want to number them for counts or ordering. In Excel this can be done with a COUNTIF function or if it's a small table you can manually do this. However if this is something you do on a recurring basis, have to do with large tables or it's a step in part of your data cleaning process you might want to use Power Query. To number rows by grouping in Power Query uses the Index function (but it's not that complicated). It's an exercise that will partition out the categories by using the group function and then applying an index number to each of the groups. This video is short so it must not be too hard to do, so check it out.