Randomize Names

[knozawa]

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

[jdunkerley79 · Accepted 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

[knozawa]

Thank you very much, @jdunkerley79!