Hi,
I was wondering if anyone had encountered a similar problem and how they resolved it. I have a table set out like this in my protocol:
probe_id | Array1 | Array2 | Array3 | ArrayN |
---|---|---|---|---|
A | 1 | 1 | 3 | 3 |
B | 2 | 2 | 4 | 4 |
C | 1 | 3 | 4 | 4 |
..etc
I want to sort the columns (not rows) by the order specified in another table:
Order | Array |
---|---|
1 | Array3 |
2 | Array5 |
3 | Array1 |
.. etc.
I've tried a few ways but can't get close to doing it, could anyone suggest a solution?
Thanks,
Liz