adding a,b,c,etc to end of item in call
I have two columns. Col A is "acct nos" where some acct nos are repeated 2,3
or 4 times and some only twice. The second column is random file names, such
as 0001325.jpg. I would like to be able to to rename the 2nd column with the
1st column acct no name and add an a,b,c, etc(however many times the account
no is listed). my "new" name would be something like 0100252401a.jpg,
0100252401b.jpg, etc.
Thanks
|