PQ - Numbering duplicates in ascending order

[sandy666]

Numbering duplicates in ascending order


Raw____________Result

2323-2323-2323-11152323-2323-2323-0000 / 000

2323-2323-2323-11152323-2323-2323-0000 / 001

2323-2323-2323-11152323-2323-2323-0000 / 002

2323-2323-2323-11122323-2323-2323-0000 / 003

2323-2323-2323-11112323-2323-2323-1111 / 000

2323-2323-2323-11122323-2323-2323-1111 / 001

2323-2323-2323-11152323-2323-2323-1111 / 002

2323-2323-2323-11152323-2323-2323-1111 / 003

2323-2323-2323-00002323-2323-2323-1111 / 004

2323-2323-2323-11152323-2323-2323-1111 / 005

2323-2323-2323-11112323-2323-2323-1111 / 006

2323-2323-2323-11122323-2323-2323-1112 / 000

2323-2323-2323-11152323-2323-2323-1112 / 001

2323-2323-2323-11122323-2323-2323-1112 / 002

2323-2323-2323-11112323-2323-2323-1112 / 003

2323-2323-2323-11152323-2323-2323-1112 / 004

2323-2323-2323-11122323-2323-2323-1115 / 000

2323-2323-2323-11152323-2323-2323-1115 / 001

2323-2323-2323-11112323-2323-2323-1115 / 002

2323-2323-2323-11112323-2323-2323-1115 / 003

2323-2323-2323-11152323-2323-2323-1115 / 004

2323-2323-2323-00002323-2323-2323-1115 / 005

2323-2323-2323-11152323-2323-2323-1115 / 006

2323-2323-2323-00002323-2323-2323-1115 / 007

2323-2323-2323-11112323-2323-2323-1115 / 008

2323-2323-2323-00002323-2323-2323-1115 / 009

2323-2323-2323-11112323-2323-2323-1115 / 010



// Table1
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Group = Table.Group(Source, {"Raw"}, {{"Count", each _, type table}}),
List = Table.AddColumn(Group, "List", each [Count][Raw]),
Extract = Table.TransformColumns(List, {"List", each Text.Combine(List.Transform(_, Text.From), ","), type text}),
Divisor = Table.AddColumn(Extract, "Divisor", each List.Count(Text.Split([List],","))),
ListNumber = Table.AddColumn(Divisor, "Number", each {0..[Divisor]-1}),
Expand = Table.ExpandListColumn(ListNumber, "Number"),
TypeText = Table.TransformColumnTypes(Expand,{{"Number", type text}}),
TPS = Table.AddColumn(TypeText, "TPS", each Text.PadStart([Number], 3, "0")),
Mrg = Table.CombineColumns(TPS,{"Raw", "TPS"},Combiner.CombineTextByDelimiter(" / ", QuoteStyle.None),"Result"),
SortAsc = Table.Sort(Mrg,{{"Result", Order.Ascending}}),
TSC = Table.SelectColumns(SortAsc,{"Result"})
in
TSC