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
Solved! Go to 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!
@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!
User | Count |
---|---|
135 | |
83 | |
63 | |
57 | |
55 |
User | Count |
---|---|
212 | |
109 | |
88 | |
82 | |
76 |