Hi I have a data set containing names, addresses, phone numbers etc and I need to randomise some of the data so I can share it. Ideally I want to change all the first names. Is there anyway I can have a list of say 5 names I choose and then randomly apply them to all the names in my data set e.g. Data Set Name Original: 1. David 2. John 3. Robbie 4. Josh 5. Alex 6. Toby 7. Alan 8. Nigel 10. Ben 5 names used to randomise: Peter Paul Mark Simon Ryan Data Set Name after randomisation: 1. Peter 2. Simon 3. Peter 4. Ryan 5. Ryan 6. Mark etc... Any help would be greatly appreciated.
... View more