So a basic example of my problem is
I have my data like this
e 8
x 5
y 3
but I actually want it to be ordered by a column I already have that is (a random order)
x
y
e
Is there a way to map values across so that
e 8 x 8
x 5 becomes y 3
y 3 e 8
To sum up.
I have my number in a order with multiple columns.
I want to sort by another column that is the same as the 1st column but in a random order
Bookmarks