Need to automate unique identifier
I have a file containing resources and a resource could be listed multiple
times. Their user ID is a key for reporting, but of course this is listed
multiple times as well.
To handle this currently, another column was inserted with their IDs copied
into it. If a user is listed more than once, than a letter is appended to
their user ID to make it unique. For example: smithj is listed on 3 rows
and the IDs would appear as : smithj, smithjx, smithjy (where the x and y
are appended to subsequent lines).
Is there a way to automate appending a letter to the user ID? Typically a
resource wouldnt have more than 4 lines, so Im only looking to append x,
y and z.
|