Scramble Data

Hello - long time lurker, 1st time poster!

I work for a school district as a technology trainer so I teach MULTIPLE skillsets on a daily basis. We deal with different depts in the district and set up their training courses for new employees. All data is student data which of course is highly confidential. I often have to create dummy reports so that employees can learn how to manipulate the raw data pulled from the system. I need a way to scramble data (student name, student number, teacher name, employee number, etc.). Often a report will include multiple rows of the same student information. I need to be able to scramble the name and associated student number....but of course keep the SAME scrambled data for both student name and number.

Attached is an example (not the thousands of rows/columns in a typical report. Any quick way to do this?

Thank you!
Don

This worked perfectly, thank you VERY VERY much!!!!!