Hello,
I would like to randomize names.
Sample input:
Sample output:
First | Middle | Last |
Alex | C | Honda |
Justin | Melvin | |
Kerry | D | Lewis |
Scott | W | Peeler |
Chris | Suzuki | |
John | E | Toyota |
Andy | Winwood | |
Pole | B | Dever |
Tony | A | Smith |
Does anyone know how to randomize names?
Sincerely,
Kazumi
Solved! Go to Solution.
How about the following:
1. Transpose so data is row based
2. Add a Random column
3. Rank within the field (FIrst, Middle, Last) using a Multi-Row formula
4. Crosstab to make the random names.
This will generate the same size of data if you want a larger random set then I would do similar instead of ranking would just make random numbers equal to data set size.
Sample of the first method attached. If you need a sample of second happy to adjust
Thank you very much, @jdunkerley79!