Bob Mehew
Well-known member
I am after some help with a small computing task. Basically I want to acquire a two column list, the first column containing numbers 1 to 20,000. The second column is the bugger in that I want it filled with a 6 character set of random letters which are not repeated. I then want a program which will take an Excel spread sheet (or csv file) and use the two columns as a look up table to switch each indivdiual number to a unique 6 character value. The request arises from a task in which I want to transfer BCA membership numbers into an equivalent unique set of characters to anonymise the data. I can then pass on the changed data to someone who can do some analytical work on the data sets without compromising the Data Protection Act. Please PM me if you can help.