Distinct Row Numbers based on Column value

[robcrockford]

Afternoon, 

I'm trying to ascertain whether it is possible to add a column that displays a sequential number for each row that has a duplicate reference. For example I have a column of references where it is possible to have multiple rows. I wish to append a number to each reference based on row count number:

Reference	Seq Row	Appended
101	1	101-1
101	2	101-2
101	3	101-3
102	1	102-1
102	2	102-2
103	1	103-1
104	1	104-1
105	1	105-1
105	2	105-2
105	3	105-3

Is this possible?

Thanks in advance

[Sean · Accepted solution]

@robcrockfordYou can do this in the Query Editor

1) Group By

2) Add Custom Column {1..[Count]}

3) Expand to New Rows

4) Remove Column

5) Merge Column (Rename resulting column if you'd like)

6) Close & Apply

Hope this helps!