Trick 014 Creating sequence number each group with power query

 In Excel with simple spreadsheets or without complicated requirements, the numbering is done easily.

But when there are many different groups of objects in the spreadsheet, we want to number each group one by one, to do this on a simple Excel spreadsheet will be very difficult and complicated.

In Excel there is a Power Query application. The power of power query is very low when we take full advantage of its features. It will make the group numbering easy for you.

Here's an example to do the job of creating each group with a sequence number.

Link to download excel file.