Unique ID for GUI's

[Bilal_321321]

Hi All,

I need help with a formula to assign a unique number to a list of ID's. The table below shows what I am trying to do:

My mind is running a blank and I can't think of the correct search terms. Any help would be appraciated

[Zubair_Muhammad · Accepted solution]

@Bilal_321321 

Using Query Editor>>select column GUI>transform tab>Group by

then do as follows

Now add an index column

Now expand the all column to new rows