Randomize field order

[JR1]

This is a rather simple question, yet I am stumped on how it can be achieved.

I have a finalized list of items, and I want to shuffle them so that they are all in a random order.

Before Randomization

Field  1

1

2

3

4

5

After Randomization

Field 1

2

4

1

5

3

What is the simplest way to go about producing this output?

[MarqueeCrew · Accepted solution]

I like this approach:

In the formula tool, create a field with a DOUBLE type, let's call it SortOrder with the following formula:

Rand()

Now let's sort the data on SortOrder (ascending or descending).

The data will sort differently on each run.

Cheers,

Mark

[JR1]

Works great!  Thank you very much!