Create number/character range based on a list of numbers/characters

[Rob5555]

Hello,

I have a list of numbers and number/character mixes like the below:

1000

1001

1002

1004

1005

1006

1M27

1M28

1M29

1M31

1M32

1J78

1J79

1J80

I would like the output to look like the following:

Name	Min	Max	Count
Range 1	1000	1002	3
Range 2	1004	1006	3
Range 3	1M27	1M29	3
Range 4	1M31	1M32	2
Range 5	1J78	1J80	3

Is there any way it is possible to create a flow to do this automatically?

I was able to create the flow I'll attach below to perform my ask for numeric values, but can't figure out how to get it to work on the number/character mix values like "1J78"

I would really appreciate and input on this issue, thank you in advance!

Rob