Randomize Names

Question

Hello,

I would like to randomize names.

Sample input:

Sample output:

FirstMiddleLastAlexCHondaJustin MelvinKerryDLewisScottWPeelerChris SuzukiJohnEToyotaAndy WinwoodPoleBDeverTonyASmith

Does anyone know how to randomize names?

Sincerely,

Kazumi

Randomize Names.xlsx

jdunkerley79 · Accepted Answer

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